Constructing a SQL statement to filter dates 1

[logo]

I am connect to Access 2000 via ADODC and am trying to filter my data according to a "date" field. This field is actually a "date/time" field, but only displays dates like 9/26/2001 in the table.

I'm not sure why this does not work--and what I need to do to fix it.

select date from (tablename)
where date = '9/26/2001'

 

[TheInsider]

Because the database is an Access database, you should enclose the date in # #, instead of ' '. The ' ' works with SQL Server and MySQL though.