Ordering Dates
Posted: Mon Feb 05, 2007 3:26 pm
I have a database of information that contains a date_completed field with the type of DATE 0000-00-00.
When I go to print out these fields and I want them to print date_completed DESC. Dates in January 2007 display at the end and dates from December 2006 print at the begining. How do I make the dates from January 2007 print at the top.
Meaning I want to know how to print out the dates according to year, month, then day. I don't want it to put all of the dates together that have a month of 01 together if they are from different years.
When I go to print out these fields and I want them to print date_completed DESC. Dates in January 2007 display at the end and dates from December 2006 print at the begining. How do I make the dates from January 2007 print at the top.
Meaning I want to know how to print out the dates according to year, month, then day. I don't want it to put all of the dates together that have a month of 01 together if they are from different years.