date comparison 1

[brownfox1]

This has got me. I have a table "Docket" with one record in it that's a date in "general date" "date/time format". 01/08/2007 17:45:00
But when I run this query:

SELECT * from Docket WHERE Docket.Date > #01/08/2007 13:43:00#  AND Docket.Date < #01/08/2007 21:43:00#

I get no result, but when I run this:

SELECT * from Docket WHERE Docket.Date > #01/08/2007 13:43:00#

I get this result: 01/08/2007 17:45:00
T.I.A

 

[PHV]

Use non ambiguous date format:
SELECT * FROM Docket WHERE Docket.Date > #2007-08-01 13:43:00# AND Docket.Date < #2007-08-01 21:43:00#

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886