P
Paul
Hi all,
I'm building a sort of calendersystem with the ability for
users to make reservations for meetingrooms. All
reservations are stored in an Access database. Now I would
like to show all reservations in a graphical way. I made
12 labels (7.00 am till 7.00 pm), and if a certain time is
booked it should be red.
Right now I try to compare each label with a database
entry like this:
strStart = dbRead("Start") 'type date
timetocompare = #2:00:00 PM# 'type date
If strStart > timetocompare Then
label red...
Else
label green..
end if
The problem is that strstart is always greater then
timetocompare (no matter what). Strstart=#12/30/1899
9.00:30 AM# and timetocompare=#2.00:00 pm#
Can anyone tell me how I can compare these time values? Do
I have to work with AM/PM?
Thanks in advance,
Paul
I'm building a sort of calendersystem with the ability for
users to make reservations for meetingrooms. All
reservations are stored in an Access database. Now I would
like to show all reservations in a graphical way. I made
12 labels (7.00 am till 7.00 pm), and if a certain time is
booked it should be red.
Right now I try to compare each label with a database
entry like this:
strStart = dbRead("Start") 'type date
timetocompare = #2:00:00 PM# 'type date
If strStart > timetocompare Then
label red...
Else
label green..
end if
The problem is that strstart is always greater then
timetocompare (no matter what). Strstart=#12/30/1899
9.00:30 AM# and timetocompare=#2.00:00 pm#
Can anyone tell me how I can compare these time values? Do
I have to work with AM/PM?
Thanks in advance,
Paul