6 Months or older date query issues

S

stickman373

Hi,

I'm running the following query through an ASP script:

SELECT COUNT(*) AS resultcount FROM facilities WHERE mod_date <
12/21/2005;

I know for a fact in the access database that the mod_date for one of
the entries is set to 6/1/2001 yet the number of results generated by
the above query is always equal to zero.

Any ideas what the issue is?
 
D

Douglas J. Steele

Dates need to be delimited with #:

SELECT COUNT(*) AS resultcount FROM facilities WHERE mod_date < #12/21/2005#
 
Top