title: SQL Select between dates
body: <p>I am running sqlite to select data between two ranges for a sales report. To select the data from between two dates I use the following statement:</p>
  <pre><code>SELECT * FROM test WHERE date BETWEEN &quot;11/1/2011&quot; AND &quot;11/8/2011&quot;;
  </code></pre>
  <p>This statement grabs all the dates even those outside the criteria. The date format you see entered is in the same format that I get back. I'm not sure what's wrong.</p>