Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello experts,
I want to color the status of an incident. If the date of incident is already passed 3 days of current date,
then it is overdue (color as Red). If it is still below 3 days from the current date, it is colored as Green.
Please help me to code the query statement please....
Thank you in advance.
Regards,
Zety
If you are using a table chart you can try something like this in the background color formula expression:
= IF(incidentdate<=(Today()-3), 'Red', if(incidentdate<=Today() and incidentdate>today()-3, 'Green'))