By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,271 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

Access 2007 Old Date format

P: 2
Hi folks !

I'm not able to get a date before 01/01/1930 formatted as short date (dd/mm/yy).
It is always formatted as dd/mm/yyyy.

Any idea?

Oct 11 '07 #1
Share this Question
Share on Google+
4 Replies

Expert Mod 10K+
P: 12,366
A two digit year can only be used if there's an assumption on what the first 2 digits are. I don't know the exact setting for Access but it looks like the two digit years start at 1930 and ends on 2029. If 1929 were formatted with a two digit year, then Access would mistake it for 2029.
Oct 11 '07 #2

P: 2
It seems to be a good reason.

Thank you,

Oct 12 '07 #3

Expert Mod 10K+
P: 12,366
Good luck.
Oct 12 '07 #4

Expert Mod 15k+
P: 31,494
The cut off point is set in Windows (accessed via Control Panel). I believe the default setting is 2029 generally though I always set mine to 2059.
Oct 12 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.