title: Finding date between start date and end date
body: <p>I want to check whether a date is between start date and end date.</p>
  
  <p>i have added a where clause</p>
  
  <pre><code>where datepaid between '2010-04-01' AND '2010-04-15'
  </code></pre>
  
  <p>but the problem is that it excludes '2010-04-15'.</p>
  
  <p>It should include end date also how can i do this?</p>
  
  <p>Please help me on this</p>
  
  <p>Regards,</p>
  
  <p>pankaj</p>