JSON formatting a calculated date column field

Copper Contributor

I am trying to format a calculated column that displays a date. The JSON code compares the date with now() and colours it red if it's before this today's date. Unfortunately, it doesn't work correctly. It colours dates 2 months away.

If I put the same code on a non-calculated field it works OK.

Both fields are set to store as Date only

0 Replies