AnsweredAssumed Answered

Searching between StartDate/Time and EndDate/Time

Question asked by brian.curran on Nov 4, 2012
Latest reply on Nov 5, 2012 by brian.curran

Title

Searching between StartDate/Time and EndDate/Time

Post

     Hi,
     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:
     Start Date
     Start Time
     End Date
     End Time

     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.

     Thanks
     Brian.

Outcomes