Date Question
Comments
-
Hello,
I’m creating a report with color rules based on dates. And currently I’m trying to make a line turn red if it’s after 3 days of the date it was completed.
However when I test my rule and I make my completed date the first of this month it failed. Why? Is my logic wrong? Any help would be appreciated.
Thanks. -
If you want to make the rule evaluate true (row will be red) if the CompletedDate is more than 3 days in the past, this rule should work for you:
4/1 < 4/22 = trueA quick note, I believe the Is Before and Is After evaluators in a rule are not working properly currently. You can use a compute date like I did in my example to get around this.