How to use "Edit Rules" to create a rule that highlights rows where the date value in the grid column is less than today.

[Nathan_Atkinson]

I am creating a report dashboard grid where one of the columns is a date.  I would like to highlight any rows where the date in that column is before "today" so that whenever the report is run it evaluates against that given day.

I have looked under Edit Rule-->Value and under Edit Rule--> A Date Occurring.  I don't see this option.  In fact my "A Date Occurring" options are not even the same as what I see in the MRG.  They are only: yesterday, today, tomorrow, last week, this week, next week, last month, this month, next month.  There is nothing else.  

And if I use Value and less than, I am forced to select a specific date.  Does anyone know how to accomplish this?

Thanks

[Eric_Beavers · Accepted solution]

What about using an Expression instead?

Here is an example of using Doc Date to change the row color if the doc is older than 6 years.

You can change the AddYears() to AddDays(Now(),-1) for your business case

My example:

[Document Date] <= AddYears(Now(), -6)

Config (right click on grid > select Edit Rules)

[Nathan_Atkinson]

Great idea. Thanks!