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', '')"
}
}

Thank you,
the article is not clear ....

https://kb.webcon.pl/zaawansowane-kolorowanie-raportow/
https://kb.webcon.pl/kolorowanie-komorek-w-raportach-aplikacji/

help is not helping ...
https://docs.webcon.com/pl/docs/2024R1/Portal/Reports/Views

we need tutorial ... user voice ?
links to dev part of portal (with explanation) .. are death as well ...
refering to:
[quote="webcon"]
Konfiguracja w trybie zaawansowanym jest możliwa przy użyciu formatu JSON – schemat tworzenia takiej konfiguracji znajdziesz pod linkiem: http://developer.webcon.com/json-schemas/v1/column-formatting.schema.json.
[/quote]

----edit----
should I go here? https://files.webcon.com/bps/reports/column-formatting.schema.v3.json

Yeah, this link: https://files.webcon.com/bps/reports/column-formatting.schema.v3.json is the latest version of schema, which shows up on choosing Advanced formatting, so this is the best place to check the schema.

Mixing schema with this article: https://kb.webcon.pl/zaawansowane-kolorowanie-raportow/ leads to some possibilities, but there are so many options that I don't think a single article will be able to cover them.