02-07-2024 01:13 PM
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
02-07-2024 02:03 PM
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)
02-07-2024 02:03 PM
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)
02-07-2024 03:08 PM
Great idea. Thanks!
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.