Searching between StartDate/Time and EndDate/Time
I'm trying to 'Find' a set of records between two dates including start and end times.
I have an Events table which lists records with the following fields:
I can retrieve records from Start Date to End Date but I want to narrow this found set down by time as well. For example, from 17:00 on the 05th of November to 05:00 on the 06th of November.
Any suggestions? I've spent most of the day experimenting with Global fields, calculation Timestamps etc.