How can i use Now as a time filter in reports?
I need to look at records whose scheduled time < Now. How can i build this?
According to the Salesforce documentation,
Now is not supported in the Report Builder. Would using
Tomorrow be sufficient for your needs, though?
Idea 1: If reporting needs to be done on a more granular level than by day, you will need to resort to custom reporting and SOQL queries.
Idea 2: Use a formula field to extract the time portion of your DateTime field. You could then group records on a more granular level, depending on what you extract (e.g. hourly, within 15 minute intervals, etc . . . )