Re: Filtering Entries by Complex Date

[Rick James]

What do you get from

SELECT needDate,
   CASE WHEN needDate IS NULL THEN '20120101'
   WHEN CHAR_LENGTH(needDate) > 6 THEN DATE_FORMAT(STR_TO_DATE(needDate, '%m/%d/%Y'), '%Y%m%d') 
   WHEN CHAR_LENGTH(needDate) > 4 THEN DATE_FORMAT(STR_TO_DATE(needDate, '%Y%m'),     '%Y%m01')
   ELSE                                DATE_FORMAT(STR_TO_DATE(needDate, '%Y'),       '%Y0101')
   END  AS ymd
 FROM courses
 HAVING ymd
   BETWEEN DATE_FORMAT(STR_TO_DATE('11/29/2013', '%m/%d/%Y'), '%Y%m%d')
       AND DATE_FORMAT(STR_TO_DATE('06/17/2014', '%m/%d/%Y'), '%Y%m%d');

?

What needDate value(s) do not work right?