title: MySQL date compare problem?
body: <pre><code>SELECT * FROM shortleavedetails WHERE employee_code='17' AND 
  (DATE(authorizeddate) &lt;= DATE(2011-1-1) AND DATE(authorizeddate) &gt;= DATE(2010-5-1))
  </code></pre>