I have a MySQL-table and in Vb I want to execute a SELECT-clause order by date. In the database the dates are stored like DD-MM-YY but I want to sort it in the order YY, MM & DD

Can anybody tell me how to use the right ORDER BY clause ?

It would help me a lot !

Thanks !

Piet

Recreanet BV, Softwareontwikkeling
http://www.recreanet.nl