changing the date

[CodeCracker0291]

This is probably a simple fix. OK I have Office XP

One of my fields is Sale Date: well i want to type the date like 10/10/03 and i want it to show 10/10/2003. Instead it turns it into 10/10/1903...wow that's an old sale. There's probably a simple fix but i just can't figure it out. I've tried an input mask to no avail. Thanks

-Jerad

 

[pbaldy]

In Control Panel/Regional Settings is a place to tell Windows how to interpret a 2 digit date. I suspect if you adjust that, Access will do what you want.

 

[CodeCracker0291]

It's not though

Yea, but the only thing is everything is set to the correct year and everything. ??
Sry,
-Jerad

 

[pbaldy]

Are we talking about the same setting? Mine is shown on the attached jpg.

 

[CodeCracker0291]

yep

yep still doesn't work

 

[pbaldy]

Curious. I can't recreate it. Can you post a sample?

 

[ghudson]

Ensure that the formatting of the text box is set to mm/dd/yyyy and create an input mask for that field like this... 00/00/00;0;#

Also, I would set the regional short date to mm/dd/yyyy.

HTH