title: How do you format dates within MS Access Queries to prevent the US/UK issue
body: <p>How do I ensure that I pick up the right number of records when filtering for dates within an Access Query:</p>
  
  <pre><code>SELECT ID, REF, SalesDate, DCount("ID","tblRecords"," Ref='" &amp; [Ref] &amp; "' AND [SalesDate]=#" &amp; format([SalesDate],"yyyy/mm/dd") &amp; "#") as EXPR1 from tblCurrent 
  </code></pre>
  
  <p>It picks up the date ok if it cannot be misconstrued such as 28-04-12, but if it is 04-06-12 it doesn't pick it up as it's assuming it's the wrong way around.</p>
  
  <p>Note that this query is not created on the fly or generated from a form etc...</p>