title: How to do select query between dates of two datetime picker?
body: <p>I have to datetimepickers FromDate and ToDate, and want to do select data between to dates, 
  I have written the query</p>
  
  <pre><code>select  * from tbl where pDate&gt;='" + dtpFrom.value + "'and pDate&lt;='" + dtpTo.value + "'");
  </code></pre>
  
  <p>This query giving error </p>
  
  <blockquote>
    <p>Data type mismatch in criteria expression</p>
  </blockquote>
  
  <p>But datatype is Date/Time in ms access table.</p>