title: Syntax for date range SQL query in OpenOffice Base
body: <p>I'm trying to SELECT based on a date in OpenOffice Base:</p>
  
  <pre><code>SELECT *
    FROM OrderTbl
    WHERE OrdDate BETWEEN #1/1/2007# AND #1/31/2007#
  </code></pre>
  
  <p>I've tried a number of variations, but nothing is working.  What is the correct syntax?</p>