title: How to select records between two dates in Access?
body: <p>I need to select records with DateTime between two dates in an Access query. The problem is that when I'm execute this query:</p>
  
  <pre><code>select *  from logs 
  where date_added &gt;= CDate("01/10/2018") 
  AND date_added &lt;= CDate("04/10/2018")
  </code></pre>
  
  <p>I need both border values but the result does not include the last day. Maybe because "04/10/2018" is converted to "04/10/2018 00:00:00" and this value is less than all date_added values of that day.</p>
  
  <p>Can I convert date_added to date only?</p>