date format mismatch

[sunshine123]

Hi,

I'm using access and my date field is formatted as shortdate - dd/mm/yyyy.
But when I try to query the table as below, there is a datatype mismatch.

SELECT *
FROM tablename
WHERE datefield='12/04/2007';

is it possible to format the date field in the sql statement or should I format the date value in the front end of the application and then pass this.

I would appreciate any help. Thanks in advance