Date Question

Unknown

Date Question

Unknown

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.

Unknown

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 = true

A 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.