Medium Date format not working

Medium date format is supposed to display date as dd-mm-yy, but I'm finding that the format is dd-mmm-yyyy for dates after about 2035. Is there any way to force the format to dd-mmm-yy?
LVL 1
MilewskpAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Format(YourDate,"dd-mmm-yy")

mx
0
mbizupCommented:
<<

Medium date format is supposed to display date as dd-mm-yy, but I'm finding that the format is dd-mmm-yyyy for dates after about 2035.
>>

How and where are you using Medium Date?


In the immediate window,

? format ("1/1/2038", "medium date")

Open in new window

Gives you what you'd ecpect from Medium Date:

01-Jan-38


<< Is there any way to force the format to dd-mmm-yy?  >>

Is this part of your question phrased as you intended?

If so, MX has the answer - dont use medium date at all (medium date formats dates as dd-mm-yy).
0
mbizupCommented:
Btw, what I posted about Medium Date is based on testing it in Access 2010 on a Windows 7 Machine.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

MilewskpAuthor Commented:
Hi all,
I'm using Access 2003 SP3. and when I use medium date or dd-mmm-yy for the format property of a form's textbox control, I get 11-Jun-29 and 17 Aug-2037 displayed.
0
mbizupCommented:
I see what you're saying...

However, I don't think that 'not working' (your question title) is quite right.

I think it's working exactly as intended, for dates after a certain point it is explicitly displaying the full year so that if you specify the full year there is no confusion through the UI about which century that date belongs to (ie: 1-Jan-1967 vs 1-jan-2067).  FOr years earlier than that, it is more likely that users will understand that a two digit date implies the present century.

However, if you enter a date such as 1/1/39 (instead of 1/1/2039), it will display the medium date with a two digit year as expected (Access 2007)

0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
What are your settings in Regional and Language Options in Control Panel?

See image ...


Capture1.gif
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
MilewskpAuthor Commented:
Hi mx,
Short date: M/d/yyyy
Date separator: /
Long Date: dddd,mmmm dd, yyyy
When a two year date is entered, intrepret as a year between 1930 and 2029.
0
MilewskpAuthor Commented:
Hi mx,
When I change to "intrepret as a year between 1959 and 2059", then i get dd mmm yy format for years up to 2059.
0
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
Actually, I was referring to the Short/Long date sample formats. You can put what ever you want - besides what's in the drop down list.

mx
0
MilewskpAuthor Commented:
Thanks everyone for your input. It appears that there is no way to force the format for controls to dd-mmm-yy unless the Regional and Language settings allow it.  Full points to mx for pointing out that this formatting is controlled by the Regional and Language settings.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.