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