Forum Discussion

SSNJeffP's avatar
SSNJeffP
Qrew Captain
5 years ago

Problem using DateTime field in formula for color coding

I'm trying to make a formula to control the colors on a report but I'm having trouble getting it to work. Here is my code: If([Due Date]>1+Today() "Reviewed", "Orange", [Due Date]>2+Today(), "Ye...
AmberPolston's avatar
AmberPolston
Qrew Cadet
5 years ago

try this:


If([Due Date]>Today()+Days(1), "Reviewed", "Orange", [Due Date]>Today()+Days(2), "Yellow", [Due Date]<Now(), "#ffcccb")



------------------------------
Amber Polston
------------------------------
SSNJeffP's avatar
SSNJeffP
Qrew Captain
5 years ago
I'm getting an error:  The operator '>' can't be applied on types datetime date


------------------------------
Jeff Peterson
------------------------------