date input mask changes when converting access 97 to access 2000

M

mspL4

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
 
J

John Nurick

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).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Input Mask - quick question 6
date+time input mask 3
Date format with input masks 2
Date format automatically changed 1
Converting Date to Julian 4
Converting Access 97 to 2000 not efficient ? 2
Access 2003 Date Input problem 3
Changing mm/dd/yy format to mm/dd/yyyy 1

Top