I have asked this question before but got nowhere. I have a date field in my Access(UK) db. The fields default value is Date().<BR>So every time a new record is added the date gets inserted. When I update the record however the updated date is in US format. <BR>I have tried various ways of fixing this but am still no closer. The date displays on my asp page corectly so why does it not get inserted corectly. I have tried changing the LCID and other formating functions on the dat but nothig works. <BR>The only time it does work is if the date is more than 12 days, ie 15/10/2004 but if it was 05/10/2004 it would appear in the database 10/05/2004. <BR>Whats going on?