title: MySQL: Find Missing Dates Between a Date Range
body: <p>I need some help with a mysql query. I've got db table that has data from Jan 1, 2011 thru April 30, 2011. There should be a record for each date. I need to find out whether any date is missing from the table. </p>
  
  <p>So for example, let's say that Feb 2, 2011 has no data. How do I find that date?</p>
  
  <p>I've got the dates stored in a column called reportdatetime. The dates are stored in the format: 2011-05-10 0:00:00, which is May 5, 2011 12:00:00 am.</p>
  
  <p>Any suggestions?</p>