Forum Discussion

JonFroderberg's avatar
Qrew Cadet
11 months ago

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
Phoenix, AZ
No RepliesBe the first to reply