Forum Academy Marketplace Showcase Pricing Features

Advance search for records created after 11pm each day

Hey everyone, I’m hoping you can help me get my head around date/times.

I am looking to search for records that have been created each day after 11pm for 30 days (or 1month).

So far I have created a search which returns all records matching the main criteria (eg: User, Field1, Field2, Created date > 30 days ago) and then apply a :filter using an Advanced Filter to extract the hour from the Created date.

This works however it is VERY slow. I think this is because it loads the entire list before filtering, which can be 10,000’s of records.

How can I set up the search constraints to return the initial search with a list containing only records created after 11pm each day for the last 30 days?

Please and thank you :pray:
Mike