how do you compare time?

[tziviak]

I have start time & end time how do I compare if startTime< endTime?
my code:
EndTime=oRs(&quot;TimeSessionStarted&quot
<%if (oRs(&quot;TimeSessionStarted&quot < EndTime ) then%>

it doesn't work-the endTime is equal to TimeSessionStarted and it's going into this statement-so it's probably not the correct way to compare it (I even tried decreasing end time by:
EndTime=DateAdd(&quot;n&quot;, -1, oRs(&quot;TimeSessionStarted&quot)%>
and then testing it-but I still got into the if statement.

I'd appreciate if anyone can help me-or direct me to a good website where I can find out the info
Thanks

 

[Tarwn]

Off the top of my head I would guess it is doing a string comparison rather than a date comparison. You could use the cDate funciton to convert the data from the db to datetype before assigning it to the variables, tat will work as long as the value from the db is not null.
ie:

Dim myDate
myDate = cDate(rs("myDateField"))

-Tarwn _{01010100 01101001 01100101 01110010 01101110 01101111 01101011 00101110 01100011 01101111 01101101}
^{29 3K 10 3D 3L 3J 3K 10 32 35 10 3E 39 33 35 10 3K 3F 10 38 31 3M 35 10 36 3I 35 35 10 3K 39 3D 35 10 1Q 19}
Get better results for your questions: faq333-2924
Frequently Asked ASP Questions: faq333-3048

 

[GaryC123]

Could do it this way

EndTime=formatdatetime(oRs(&quot;TimeSessionStarted&quot) Saturday 12.00

20.00

3.00am

Sunday [img http