title: SQLite, making a query based on Dates
body: <p>I've been searching on how to do this but am not coming up with a clear answer (maybe my resources are not that good). I need to make a SQLite query to retrieve data between two dates from a SQLite DB.</p>
  
  <p>I am trying this:</p>
  
  <pre><code>SELECT CONTACTNAME
  FROM SHIPMENT 
  WHERE DATECREATED 
  BETWEEN date('11-15-2010') 
  AND date('12-25-2010');
  </code></pre>
  
  <p>The data is in my SQLite DB as:</p>
  
  <pre><code>CONTACTNAME=VARCHAR
  DATECREATED=date (format: "11/22/2010")
  </code></pre>