title: SQL between dates
body: <p>I have table with two columns (startdate &amp; enddate) and I have two submission dates (2012-02-29 &amp; 2012-03-30) I am trying to get the data between startdate (2012-02-29) and the enddate (2012-03-30)</p>
  
  <p>I've tried</p>
  
  <pre><code> i.startdate between '2012-02-29' and i.enddate '2012-03-30'
  </code></pre>
  
  <p>but that didnt work, I've been googling this for hours with no clear answer, any help would be appreciated, thanks in advance.</p>