Date change later than 00:00

[PLiNk]

I am building booking database for a student house in Norway. Many things happen here, and different organisations book rooms for the activities. The house usually closes 03.00 in the morning, and when booking a room rhe time is usually the next effective day, thatis, later than 23.59.59 This creates a headache since closing dates from the previous night show up in queries along with starting times for this night.

In order to visualize these bookings properly we need to create a schedule-like appearance, and that requiees the computer to understand that 03.00 is LATER than 2200.

The most smooth way of solving this problem is to change the date-turning point from 00.00 to 06.00. Can this be done? How? Is there any other way of solving this problem. I would like to avoid generating a closing timestamp by code, but I have deviced a way to do this. I just want to keep things simple.

Thanks for all help.

 

[SkipVought]

Hi.

Maybe you'll have to subtract 3 hrs from each date/time entry.
[tt]
[YourDateTime]-3/24
[/tt]


Skip,

_{[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?"}

 

[ProgramError]

check the dates first before working on the time.




Program Error
Why is it, I still think in terms of spectrum BASIC!

 

[ChuckWhite]

How about checking the concatenation of the Date and Tme?

That is:
#3/15/05 23:59# is earlier than #3/16/05 3:00#

Checking Date & Time should always yield a correct result.

Does that make sense?