Dates suddenly being entered in US format!?

[danb]

Hi,

An Access database table I'm looking at has a date column, where date is entered in UK format (dd/mm/yyyy). However, upon entering the database, the date is somehow converted into US format, despite me passing the date into the table as dd/mm/yyyy.

The trouble started when someone else worked on the database - leaving us now with all of the old records in UK format (correct) but all new entries to that column in US format.

Please note, when I open the Access table, all of the dates for the past 2 years or so are fine (dd/mm/yyyy) but recently, since someone else worked on the file, the new records are appearing as mm/dd/yyyy. Within the same table column we're getting apparently mixed formats.

I'm aware of using session.lcid=2057, but would prefer just to be able to have the dates appear in the right format in the database itself rather than having to use this (I'm concerned if I use lcid, it might balls up the older, correct records in the table).

How can this have suddenly changed, and more importantly, how can I get the records into the table in UK format?

Thanks very much for your help...

 

[raskew]

Hi -

Take a look at this article http://allenbrowne.com/ser-36.html by Allen Browne.

HTH - Bob

 

[danb]

Hmm, I'm not too sure this covers my problem.

All of the entries in the table show up as dd/mm/yyyy, but when I add a new one it goes in as mm/dd/yyyy - even when I set the default value as date() (so this proves it's not to do with the format of the SQL insert statement which is the problem).

I just can't see how:

1. The format can suddenly have changed in the database column
2. How to make the default records dd/mm/yyyy

If I create a new Access database and add a date field with a default value of date() it shows as UK format, so how can I get the old database to do the same thing - it obviously used to!??

Thanks