This is probably fairly simple but I'm used to Oracle databases and I'm not sure how to do this for Access type databases. I'm trying to build a query to find a specific row. One of the fields is of type date. How do I set this up in the SQL query.

For Oracle I would have used something like this:

select * from table where date_column = to_date('1-11-2004','DD-MM-YYYY')

I tried this:

select * from table where date_column = '1-11-2004'

and it wasn't happy with the date being a string so I tried this:

select * from table where date_column = 1-11-2004

it didn't complain but it didn't work either.