title: access date format in query not working
body: <p>I have a table in date format dd/mm/yyyy in access 2007. Even in regional setting it is UK format - dd/mm/yyyy</p>
  
  <p>But when I write a query to filter records for dates from the table.</p>
  
  <p>I have to write like this #07/01/2012#. </p>
  
  <pre><code>select * from table1
  where datecolumn between #07/01/2012# and #07/03/2012#
  </code></pre>
  
  <p>If I write #01/07/2012# it shows no data. </p>
  
  <pre><code>select * from table1
  where datecolumn between #01/07/2012# and #03/07/2012#
  </code></pre>
  
  <p>But from 13/07/2012, if I write using the format #13/07/2012#, it works fine.</p>
  
  <pre><code>select * from table1
  where datecolumn between #13/07/2012# and #14/07/2012#
  </code></pre>
  
  <p>I have an issue till 1st July to 12th July. I'm not sure where is the problem.</p>