Input mask for date field not working

[iglobalusa]

I have a form with a date field for users to input the date of birth. The data type is Date/Time and the format is Short Date. The input mask is:
99/99/00;;_

Everything is fine until a user enters any year from 1911 to 1929. So if the date of birth is 03/23/28, Access 2003 converts it to 03/23/2028 instead of 03/23/1928. It works fine if a user inputs 03/23/30 with the result as 03/23/1930, or 03/23/56 with the result as 03/23/1956.

Since the users are doing a high volume of data entry, I'm saving them from typing two additional keystrokes by entering a two digit year instead of four in the input mask.

Has anyone come across a similar problem with the input mask?

Thanks for your reply.

 

[Trevor G]

Try replacing the mask to 00/00/00 see if that works, I think you have used the wizard hence the ;;_

 

[iglobalusa]

Try replacing the mask to 00/00/00 see if that works, I think you have used the wizard hence the ;;_

Tried what you suggested but it's still ending up as 2028 instead of 1928.

 

[DCrake]

I have this memory that this is a setting that can be applied, Miscrosoft products assumes all dates entered without the century years assumes that everything after a certain value is treated as being 20 otherwise it is 19.

 

[iglobalusa]

I have this memory that this is a setting that can be applied, Miscrosoft products assumes all dates entered without the century years assumes that everything after a certain value is treated as being 20 otherwise it is 19.

Is this a system setting that can be changed? Or am I left with no choice but to modify the input mask so the user enters a four digit year?

Thanks for your reply.

 

[DCrake]

AS a workaround you could you can user a before update event to check the year part of the date and if the century is wrong then change it 19.

 

[iglobalusa]

AS a workaround you could you can user a before update event to check the year part of the date and if the century is wrong then change it 19.

Thanks, I'll try that although I may just have the user input a four digit year to simplyify things.

 

[namliam]

Y2K bug, not entering the century is bad...

 

[Trevor G]

It would be easier to mask 00/00/0000, sorry to say.