title: Convert String to Date in MS Access Query
body: <p>I am trying to retrieve data from my <code>access</code> table based on <code>Date</code> column. My requirement is to display everything greater than the certain value. I am trying to <code>cast</code> my value, which is a <code>string</code> using Format <code>&amp;CDate</code> function with <code>datetime</code> data type and it throws out as Overflow.</p>
  
  <p>Here's query :</p>
  
  <pre><code>Select * from Events
  Where Events.[Date] &gt; cDate(Format("20130423014854","yyyy-MM-dd hh:mm:ss"))
  </code></pre>
  
  <p>Sample Date Record Value from Table :  <code>2013-04-23 13:48:54.0</code></p>
  
  <p><code>Events.[Date]</code> is a Date/Time type field in <code>access</code></p>
  
  <p>How can I fix this ?</p>