Advanced coloring date fields in reports

0

Hi Michał,
I also tried to do it this way once and did not find the working solution. Instead i use a calculated column that returns 1/0 depending on whether the date is smaller/greater than current :)
But maybe someone knows how to do it using json syntax? so i join the question

Thanks Sebastian, your solution does the job!
But if someone who uses JSON syntax could give us the right syntax would be very appretiated. The document at https://community.webcon.com/posts/post/advanced-cell-coloring-in-reports/18 is not very clear on that.

Hi Michał,
Try comparing your date to 'now()'. Hope it works for you.

I'm digging an old thread, but I've faced same trouble today, and had to add something new to make it work, so why not make an update :)
This is my final config, that works for Date columns (i didn't need time part, changing today() to now() should do the work though)

{
"content": "=CurrentField",
"style": {
"background-color": "=if(date(CurrentRawValue) > today(), '#FF0000', '')"
}
}