function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
AmyJonesAmyJones 

filter report to show records amended over 4 hours ago

I am trying to amend a report to only show records that were amended over 4 hours ago.
We have a date/time field thats shows the amended time.
Can this be filtered on a report or do i need to create a formula checkbox field? Im am striggling with the formula for this.
 
Maharajan CMaharajan C
Hi Amy,

I think we can't use anything to filter report to show records amended over 4 hours ago.

Better create a formula field with number return type like below to calculate the time difference in Hours and use that field in your report.

Formula Field :  (Now() - CreatedDate )*24

In Report add filter as : Formula Field > 4 

Thanks,
Maharajan.C