Hey!,

I've just recently converted a database from Access 97 
format to Access 2000 and everything seems fine apart from 
anything to do with dates.
I've checked the table setup and the input masks on both 
databases and they are the same, but when I enter a date 
into a form, the year field automatically prompts me for 4 
digits instead of 2, and on entries where the year is 
1904, (or 00 or 01 or 02 or 03) access 2000 automatically 
assumes the date is this millenium and adds the other 2 
digits.

Any way to work around this?

Thanx in Advance

msp 

IIRC this relates to "millennium bug" fixes in Access 2000. 

In Control Panel|Regional Options, there's a setting on the Date tab
that controls how 2-digit years are interpreted.

If you omit the input mask, things will be easier for users because
Access can interpret most date formates correctly (e.g. 21 Jan 04 or
21/1/04). 

On Mon, 9 Feb 2004 02:17:32 -0800, "mspL4" <Paul.jones@whnt.nhs.uk>
wrote:

>Hey!,
>
>I've just recently converted a database from Access 97 
>format to Access 2000 and everything seems fine apart from 
>anything to do with dates.
>I've checked the table setup and the input masks on both 
>databases and they are the same, but when I enter a date 
>into a form, the year field automatically prompts me for 4 
>digits instead of 2, and on entries where the year is 
>1904, (or 00 or 01 or 02 or 03) access 2000 automatically 
>assumes the date is this millenium and adds the other 2 
>digits.
>
>Any way to work around this?
>
>Thanx in Advance
>
>msp 

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.