Scheduled Report - Filter between 2 different times (created)

[LuizM0098939804]

I'm having trouble setting up a scheduled report.

I have a standard table of internal invoices, and I need to trigger a notification only for records registered between 11 PM and midnight. How do I do this? I tried using the standard report, but I can't perform the necessary query. I also tried scripting it without conditions, but without success. Can anyone help me? Thank you in advance.

[Rampriya-S]

You can do it like this with a Scheduled Email of Report (no scripting needed).

1. Create a report on your Internal Invoice table.

2. In the filter, set Created to a relative condition, for example:

   • Created on → Last 1 hours

   • 

     
     (or “on or after → relative → 1 hour ago”)

   • 

3. Save the report.

4. Create a Scheduled Email of Report, select this report, and schedule it to run daily at 23:59:59.

When the schedule runs at 23:59:59, the relative filter “last 1 hour” will return only the records created between 23:00 and 23:59:59 for that day, and those will be sent in the email.

If this solves your issue, please mark the response as helpful so it can assist others as well.