SOLVED

JSON formatting date column

Copper Contributor

Hi all, I am trying to understand how to use the column formatting (highlighting) for dates. My goal is the following: 

Column Name: Internal Due Date

I would like the field to be green if the date is > today + 45 days

I would like the field to be yellow if the date is > today + 30 days, and

I would like the field to be red if the date is > today + 20 days.

It would be great if there was a statement that I could make for all of these in one, but I think that I may have to create a column for each color. I don't know. I can't locate an answer anywhere.

 

Can someone assist me with the best avenue to take to get this accomplished. Also, it seems like there might have to be a "between" in there somewhere.

 

Thanks for any help.

1 Reply
best response confirmed by Jamie Johnson (Copper Contributor)
Solution
I did figure this out. I modified this response for my situation. https://docs.microsoft.com/en-us/answers/questions/143256/json-dates-greenyellowred.html
1 best response

Accepted Solutions
best response confirmed by Jamie Johnson (Copper Contributor)
Solution