Time queries

[ddog171]

I need to selet events from a table that happen during a certain time period. The only problem is how do you do this when the time period involved is over two days?

In my table I have start time and end time.

EX.

Start Time/End Time
0630/0800
0800/0100
2300/0430


0400/0530
1200/1300
2200/2300


I want to select al the events that take place between 2200 and 0600. The following results should come back:

0800/0100
2300/0430
0400/0530
2200/2300

And help you can provide would be greatly appreciated.

[mhartman]

Hello:

You need to figure in a date field some how and then calculate the difference between Now and the desired date. The following may help you:

The DateDiff function displays the variance in days between the values of the OrderDate and ShippedDate fields.
'
DateDiff("d", [OrderDate], [ShippedDate])
'
The DateAdd function displays a date that is 10 days before the value of the PromisedDate field.
'
DateAdd("y", -10, [PromisedDate])

Regards
Mark

[ddog171]

I do have a date field, they are start day and end day.

Maybe I am missing your point but the query is not based off the date. I just need all the events over a certain period of time (ex. Between 2200 and 0600) regardless of the date.

Any additional explanation or help anyone can provide would be greatly appreciated.

Thank you