Simple Formula To Highlight Records As New or Updated

In the April 2021 Release Notes QB noted that the "New" and "Updated" flags on records would be retired at some point in the future. The release notes provided links to general articles about report filters and formulas without providing a specific example of a formula that can be used.

Below is a simple formula to highlight records as being "New" or "Modified". In this example the time frame is set to the past seven days.

If(ToDate([Date Created])>=Today()-Days(7),"#6BBD57",
If(ToDate([Date Modified])>=Today()-Days(7),"#F1C32B"))
//#F1C32B Update Gold
//#6BBD57 New Green

------------------------------
Jon Froderberg
PRIME Developer
Harder Mechanical Contractors
https://www.harder.com
Phoenix, AZ
------------------------------