Hi all!

I am having a rather puzzling error in a database with some dates! The date field of the database is set to show a british date - ie DD/MM/YYYY rather than the american MM/DD/YYYY.

This format works fine if the day date is higher than 12, ie 14/04/2004. However, if the day date is lower, the date is saved to the database american style - so that 3rd May 2004 becomes 05/03/2004, rather than the British 03/05/2004! As I said before, this is only with date below the 12th of the month - all dates above this value are fine!!!!

Any advice would be appreciated!!!

I've never messed much with date formats, but I would suspect that the DB is set one way (UK) and your asp (or server default) is set to another (US). You can set the asp date format via LCID:

www.4guysfromrolla.com/webtech/111299-1.shtml

However, this is just a hunch