title: how to convert string to datetime MS Access
body: <p>I am using Ms Access and below is my Query</p>
  
  <pre><code>select * from travelapproval 
  where CDate(datefrom1) &lt;=  Date() 
  and CDate(dateto1) &gt;= Date()
  </code></pre>
  
  <p>I am using datefrom1 and dateto1 are text type. It shows <code>"Data type mismatch in criteria expression."</code></p>
  
  <p>How can I convert them to datetime even I tried with CDate function.</p>
  
  <p><img src="https://i.stack.imgur.com/Bg4lP.jpg" alt="enter image description here"></p>