Short Date format -displaying as "yy" and "yyyy" ?! 2

[TeddB]

My copy of Access 2000 (9.0.2720) is displaying the Short Date format as "mm/dd/yyyy"

I installed a database on another computer with the same Access version (9.0 .2720) and it is displaying the Short Date format as "mm/dd/yy" ?!!

Any ideas on WHY?

 

[pavewayammo]

Go to the control panel then Regional Options/Setting and look at the date tab. Each computer may have the date format set differant.

James

 

[coco86]

The short date settings for your computer probably need to be changed.

Go to Control Panel -> Regional Settings and click on the date tab to make the change

 

[JeremyNYC]

Ted,

If it matters to you, do NOT rely on the regional settings of any computer, because it is FAR too easy for a user to change this on his or her own. If the display format matters, the only thing that's really going to do it for you is to build it explicity in the format property of every date control on every form and report.

Jeremy =============
Jeremy Wallace
AlphaBet City Dataworks

http://www.AlphaBetCityDataworks.com

Take a look at the Developers' section of the site for some helpful fundamentals.