Forum Discussion

JohnJohn's avatar
JohnJohn
Qrew Trainee
8 years ago

I'm trying to create a report that colors a row red if a date field has a date past 9 days

I'm trying to create a report that colors a row red if a date field has a date past 9 days - If ([Date Released for Inspection]> days+(9) ,"red","")
MCFNeil's avatar
MCFNeil
Qrew Captain
8 years ago
if more than 9 days in the future:
 If ([Date Released for Inspection]> Today()+Days(9) , "red", "")

if less than 9 days in the past:
If ([Date Released for Inspection]< Today()-Days(9) , "red", "")