6 Months or older date query issues

[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?

 

[Douglas J. Steele]

Dates need to be delimited with #:

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

 

[stickman373]

Ah that was quick. That solved it, thanks for the response.