title: BETWEEN clause in SQL
body: <p>I have a SQL statement to display data between two dates. I almost got it but there's a problem.</p>
  
  <p>If I input <code>March 1,2012 to March 7, 2012</code>.. it should show data with dates between the two.. but it also show all of the dates under March 2012.. but whenever I input March 10, 2012 to March 30, 2012 the SQL works perfectly.. any help will be appreciated. thanks</p>
  
  <pre><code>SELECT 
     agentname, noofcalls, qualified, booking, resched, 
     actualbooking, sales, remarks, 
     concat(month,' ',day,',',year) as 'date' 
  FROM 
     tblagents
  WHERE 
     (month between '" &amp; cbosmonth.Text &amp; "' AND '" &amp; cboemonth.Text &amp; "')
     AND (day between '" &amp; cbosday.Text &amp; "' AND '" &amp; cboeday.Text &amp; "')
     AND (year between '" &amp; cbosyear.Text &amp; "' AND '" &amp; cboeyear.Text &amp; "')"
  </code></pre>