title: MS Access query on DATEVALUE
body: <p>I'm trying to run a query that only included recordsa after a certain date, but the date is in text format.</p>
  
  <p>I've tried using lots of different methods but I can't get it to work</p>
  
  <p>these return 'Data type mismatch'</p>
  
  <pre><code>SELECT  DateValue([BasicStartDate]) AS [DATE]
  WHERE (((DateValue([BasicStartDate]))&gt;=#5/15/2017#));
  
  WHERE (((DateValue([BasicStartDate]))&gt;=2017-5-15));
  
  WHERE (((DateValue([BasicStartDate]))&gt;='2017-5-15'));
  </code></pre>
  
  <p>I've aslo tried using cdate but get issues with invalid use of NULL when ever i try to put a where query on the result - despite there being no nulls in the returned column before applying the where query.</p>