[AccessD] time window

John,

Would a conversion to 24Hour format make things any easier?



Mark


-----Original Message-----
From: John W. Colby [mailto:jwcolby at colbyconsulting.com] 
Sent: Thursday, February 12, 2004 9:09 PM
To: AccessD
Subject: [AccessD] time window


I need to be able to express a pure time window (not date related) from / to
and test time() as being between (inside) this time window.  This process
doesn't work across midnight, i.e. 7:00 pm is "between" 6:00 pm and 1:00 am.
However if I just do a simple compare - 7:00 PM is >= 6:00 PM but it is not
<= 1:00 am.

It looks like a "if time 2 > time 1 then use simple test for time()"  "If
Time 2 < time 1 then invert the second time comparison"

Has anyone done this already?

John W. Colby
www.ColbyConsulting.com


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com