function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Reports -Filter on Date using a dynamice date, like sysdate

I need to create a report that will be run daily by user community. It needs to filter on a Date field

but I only want to display what occurred in the last 24 hours.

In Oracle I would do "datefield >= sysdate - 1".


How do I do this in SalesForce tool?






I recently had a similar scenario where I had to create a report that displayed details of accounts created in the past 24 hours.


I found that while this cannot be achieved through directly using the report builder, you can use a formula field on the object to work out if the date/time field value is in the past 24 hours, and then base the report over this.


A full explanation, including formulas, can be found on my recent blog post - How to create a "Past 24 hours" flexible report.