title: SQL in VBA WHERE Clause
body: <p>I have been trying to add additional filter criteria to my WHERE clause in sql VBA. The previous select statement works fine, but I can't seem to get the updated WHERE clause to work. Here's what I have:</p>
  
  <pre><code>WHERE tblretirements.Applicationcancelled = 'No' 
      AND tblretirements.FirstPayDate IS NULL 
      OR tblretiremetns.FirstPayDate BETWEEN 'now()' &amp; 'Beginning of Prior Fiscal Year'
  </code></pre>
  
  <p>I am not that familiar with the <code>BETWEEN</code> statement and am positive that I am messing that up. I need to have the code dynamically reference today's date and the beginning of the prior fiscal year, which is 6/1/2017 right now. Can someone please help? Thank you.</p>