Order Date by Year then Month

[spyderman]

I'm building a script that displays a list of newsletters in the archive. The records, along with the creation date, is stored in MySQL and I'm trying to figure out how to query the records so that it comes out ordered by Year in descending order and then Month and ascending order.

If it's not possible to do that with the way I store the date in the database, how should I structure the database table so that it would be possible to do this?

Newsletter Table

Newsletterid
Title
Content
Date (yyyy-mm-dd)

[devinemke]

SELECT * FROM newsletters ORDER BY YEAR(date) DESC, MONTH(date) ASC

[spyderman]

That worked great, thanks!