title: How to get data between two dates using a Query in Access 2016
body: <pre><code>SELECT SignIn.VisitorFirstName, SignIn.VisitorLastName, SignIn.SignInDateTime
  FROM SignIn
  WHERE (((SignIn.[Complete])=Yes)) AND SignIn.SignInDateTime between #08/08/2016# and #08/10/2016#
  </code></pre>
  
  <p>The SignInDateTime is a Date/Time in MS Access 2016</p>
  
  <p>The data in the field looks like <strong>8/1/2016 12:30:11 PM</strong></p>
  
  <p>I am trying to find records between dates (not really caring about the time)</p>