Ordering by a date

I have just encountered a problem with my site: http://curt.rallystuff.net

I have been ordering records by a field in the format Date/Time. I thought this was working fine, but now we are in a new month I have discovered it doesn't as it is only ordering it like a normal number. So values of 15/02/2006 00:00 come ahead of 01/03/2006 00:00

Is there a way round this?

Thanks.
Curt.

It turns out its not anything to do with the ORDER clause. That is all working fine. Instead the format it is saved in has changed from dd/mm to mm/dd. I am still trying to figure out whats wrong there though.

In your insert code, are you formatting the date in that way before you do the insert?

In your insert code, are you formatting the date in that way before you do the insert?
Yes I am inserting it as 'DateTime'. However the problem is when I update records.

Why not just insert and update in the same standard format, and then when you display do some date formatting on the field?

Thanks for your help. I think the problem is fixed now. Although I'm not certain. If the same problem happens next month I will have to ask for some more help :).