Order by Date

[datoshway]

Have a date field with a mysql date format that is B d, Y

Can't seem to get my query to sort correctly.  See below. Thanks in advance.

 

	$strQuery				= "SELECT * FROM tblVolunteer ORDER BY DATE_FORMAT( `strDate`, '%B%d,%Y' ) DESC";
$queryGetVol		= db_query($strQuery);

[PFMaBiSmAd]

Use -

ORDER BY strDate

 

The YYYY-MM-DD format can be sorted because the fields making it up are left-to-right, most-significant-digits (year) to least-significant-digits (day). Your B d, Y formatted value cannot be sorted.