title: Ms Access VBA Date filter
body: <p>I'm self studying a VBA code, I got one question.
  Hope can get your help.</p>
  
  <p>Here is my situation:</p>
  
  <p>I've 15 records in the table, they're date value like: <br/>
  31 Jan 2016, 29 Feb 2016, 30 Nov 2016, 31 Dec 2016<br/>
  the field name is [dayTo]</p>
  
  <p>And I've two Forms,<br/>
  1st Form = "F_temp", a txt box "date0" in this form.<br/>
  2nd Form = "F_visitorRec", this form will show the record from [dayTo]</p>
  
  <p>I'd like to made a openForm with condition like:</p>
  
  <pre><code>DoCmd.OpenForm "F_visitorRec", acNormal, , "[dayTo] &gt;= #" &amp; Me![date0] &amp; "#"
  </code></pre>
  
  <p>But I never success, if I input 01 Nov 2016, it will show all 15 record.<br/>
  If I input 09 Nov 2016, it will show the date large than September.<br/>
  If I input 13 Nov 2016, the result is correct, <br/>it can show the record lager than 13 Nov 2016.<br/>
  I know this problem should related to the date format, but I try many method but still can't fix.</p>
  
  <p>Hope can get your help.</p>