title: SQL Access 2010 querying by date "Data type mismatch in criteria expression."
body: <p>I'm trying to make a query in Access 2010, but it keeps giving me this error "Data type mismatch in criteria expression."</p>
  
  <p>The query is simple as</p>
  
  <pre><code>SELECT *
  FROM mytable
  WHERE date = '23-07-2013'
  </code></pre>
  
  <p>Any wonder why?</p>