title: date range not working in vb with ms access database
body: <p>I need to update the rows where <code>pdate</code> (a date field) is not between the 1st and 20th day of current month and year.</p>
  
  <p>I am using the code written below, but it gives an error saying "too few parameters expected 1". I am using MS Access 2007 as database.</p>
  
  <pre><code>cn.Execute "update water set prel = (prel + (mmt * (tx / 100))) where pdate not between 1-" &amp; Format$(Now, "MMM") &amp; "-" &amp; Format$(Now, "YYYY") &amp; "  and 20-" &amp; Format$(Now, "MMM") &amp; "-" &amp; Format$(Now, "YYYY") &amp; " "
  </code></pre>