JSON formula is not working

Question

This formula will:

1. Highlight in Yellow if the date is past due (i.e., the date in the column is in the past).
2. Highlight in Orange if the date is within the next 14 days.
3. Highlight in Yellow again for dates within 30 days.
4. Light Gray for any dates beyond 30 days.

Updated JSON Formula:

json
Copy code
{

Answer 1

Hi @Olga Schmitt ,

Thank you for posting in this community.

Using the follow json to display date column in different colors according to time:

{
  "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
  "elmType": "div",
  "txtContent": "@currentField",
  "style": {
    "background-color": "=if(((@currentField) - @now <= 0) || (((@currentField) - @now <= 2592000000) && ((@currentField) - @now >= 1209600000)), 'yellow', if((@currentField) - @now <= 1209600000, 'orange', 'gray'))"
  }
}

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.