title: How to format dates in microsoft access queries
body: <pre><code>SELECT convert(varchar, getdate(), 101)
  </code></pre>
  
  <p>In Microsoft SQL Server, the above query returns the current date in the format  </p>
  
  <blockquote>
    <p>mm/dd/yyyy - 05/01/2014</p>
  </blockquote>
  
  <p>What is its Microsoft Access query equivalent? I have tried <code>CDate(MyDateValue)</code> but this does not retain leading zeroes. In the example above, it returns </p>
  
  <blockquote>
    <p>5/1/2014</p>
  </blockquote>
  
  <p>but i need the leading zeroes. </p>