Skip to main content
Question

Simple Formula To Highlight Records As New or Updated

  • June 15, 2023
  • 0 replies
  • 56 views

Forum|alt.badge.img+6

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
------------------------------
This topic has been closed for replies.