title: MySQL Query - Records between Today and Last 30 Days
body: <p>I want to return all records that were added to the database within the last 30 days.  I need to convert the date to mm/dd/yy because of display purposes.  </p>
  
  <pre><code>create_date between DATE_FORMAT(curdate(),'%m/%d/%Y') AND (DATE_FORMAT(curdate() - interval 30 day,'%m/%d/%Y')) 
  </code></pre>
  
  <p>My statement fails to limit the records to the last 30 days - it selects all the records.</p>
  
  <p>Can anyone point me in the right direction?  It feels like I am close.</p>
  
  <p>Thanks and have a great week.</p>