How to label status if the date is overdue or not

[nurulizzaty]

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

[Steven_Haught]

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'))