title: Access SQL Date Format
body: <p>How can I retrieve a record based on a Date property? I'm trying:</p>
  
  <pre><code>WHERE Meetings.[MDate] = '16/12/2011'
  </code></pre>
  
  <p>which is the format I use but I get :</p>
  
  <blockquote>
    <p>"Data type mismatch in criteria expression"</p>
  </blockquote>
  
  <hr>
  
  <p>Problem solved: It should have been:</p>
  
  <pre><code>WHERE Meetings.[MDate] = 16/12/2011
  </code></pre>
  
  <p>No quotation marks. </p>