order by with regard to year

[kappaluppa]

I am using
"SELECT *, DATE_FORMAT(date2, '%m-%d-%Y') AS date_format FROM $TableName ORDER BY date_format DESC"
but it orders by month, so the years are not in order.

For instance 1/1/2001 and 1/3/2002 are right next to each other instead of 1/3/2002 being at the top of the list.

Any suggestions on how to fix this problem.

I want the date to be listed as mm/dd/yyyy

---

The other thing I'd settle for is to break out the articles in groups of 2001 & 2002 and order within those groups.

THANKS!

(i don't know what I'd do without the people who help on thisboard!!!)

[amcgrath]

do em a favor, try sorting it by date2, not date_format...

[kappaluppa]

THanks to everyone who suggested I try sorting by date2. It did the trick!

[amcgrath]

Umm, its just you and me on this thread Kath 😉

[kappaluppa]

lol!

no, i'm not seeing double. 🙂
i guess the forum was down for a while because people had trouble posting and were sending me emails directly. They all said the same thing, btw...

so thanks again!
...don't know what i'd do w/o you guys!