title: ms access 2010 not getting data when giving the condition year to year
body: <p>I have a weird issue with MS ACCESS 2010.<br/>
  I have a table RawData with column <code>TaskDate</code> (format is Memo). When I use the below query I am getting the desired data,<br/></p>
  
  <pre><code>`select * from RawData where TaskDate between '01/01/2012' and '12/31/2012'`
  </code></pre>
  
  <p>But when I use the below query I am not getting any data:</p>
  
  <pre><code>select * from RawData where TaskDate between '01/01/2012' and '01/01/2013'
  </code></pre>
  
  <p>I don't understand the problem as the data comparison was not happening with this 'Year' value. Please help on this</p>