Forum Discussion

Jamie Johnson's avatar
Jamie Johnson
Copper Contributor
Dec 08, 2020
Solved

JSON formatting date column

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.

Resources