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
Debbie61Debbie61 

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?

 

Thanks

Christopher_Alun_LewisChristopher_Alun_Lewis

Hi,

 

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.