You need to sign in to do that
Don't have an account?
Debbie61
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
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.