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