title: Select from MS Access Table between two dates?
body: <p>I have an MS ACCESS Table with a string field i use to store dates (I have my reasons to not use a type Date), Is there a way to select rows from the table between two dates ? cuz everything i tried doesnt seem to work, it confuses years, days and months, here is what i tried :</p>
  
  <pre><code>select  *  from audience where Format(auddate, "dd/MM/yyyy") between #01/06/2014# and  #01/08/2014#
  select  *  from audience where Format(auddate, "dd/MM/yyyy") &gt; #01/06/2014# and Format(auddate, "dd/MM/yyyy") &gt; #01/08/2014#
  </code></pre>
  
  <p>among others and i get some meaningless results :</p>
  
  <p>AudDate<br>
  25/06/2014<br>
  18/09/2012<br>
  12/11/2012<br>
  28/01/2013<br>
  08/02/2011<br>
  13/10/2011<br></p>
  
  <p>Thanks in advance.</p>