SQL Access 2010 querying by date "Data type mismatch in criteria expression."

Question

I'm trying to make a query in Access 2010, but it keeps giving me this error "Data type mismatch in criteria expression."

The query is simple as

SELECT *
FROM mytable
WHERE date = '23-07-2013'

Any wonder why?

Answer 1

Access enclosed a date with # signs to indicate a literal value of date. And using a single quote in your case means you are comparing a String/Text with a Date data type thus the Data Type mismatch. It should therefore be:

 SELECT *
 FROM mytable
 WHERE date = #23/07/2013#

Answer 2

SELECT *
FROM mytable
WHERE date = #7/23/2013#