How do you order by date?

[sjf]

This may seem like a stupid question but how do you order a recordset by date?

I have a database that stores the date in the following format:
Field 1 - Day
Field 2 - Month
Field 3 - Year

I want to be able to sort this using an SQL query, anyone got any ideas?

 

[Guest_imported]

Select field1,field2,field3 from table_name order by field3 desc,field2 desc,field1 desc

This will sort recordset by year(from latest to earliest), then within each year - by month(from latest to earliest) and at last - within each month - by day(from latest to earliest)

 

[mrichards]

if the month is jan or january dont forget to use the

month(month_field) to get the right order.

Mark