Query - Retrieving Data between certain times

[keeno]

Hello

I would like some assistacne with how I can extract specific data.

I have a report in Crystal XI which retrieves the number of records on a daily basis.

However I want to be able to only return records which have a SUBMIT DATE/TIME between 02:00am and 06:00am on each day.

Is there a simple formula or anything else which can help me extract this specfic data

Thanks

David

 

[lbass]

Add the following to your record selection formula:

time(table.submitdatetime} in time(2,0,0) to time(6,0,0)

Or you might want to exclude 6am and make the end time:

to time(5,59,59)

-LB