Get ready for BLACK FRIDAY shopping starting in

Forums

ASP

This topic is locked

order by: Eur. vs. US. date format problem!

Posted 02 Apr 2004 02:02:08
1
has voted
02 Apr 2004 02:02:08 Claudio Huyskens posted:
If I use an order by date in my recordset on a European date format, it starts ordering by days instead of ordering by month.

Has anybody any clue how to solve this problem except for changing my database date format to a U.S. format.

I appreciate any comment.

Regards

Claudio

Replies

Replied 02 Apr 2004 13:46:20
02 Apr 2004 13:46:20 Claudio Huyskens replied:
sorry, problem solved. Database field was configured as textfield instead of date field.

Reply to this topic