Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208339 - Last Review: June 30, 2006 - Revision: 3.0
ACC2000: Years 00-29 Default to Year 2000 When Typed as M/D/YY
This article was previously published under Q208339
Novice: Requires knowledge of the user interface on single-user computers.
When you type a date in the format M/D/YY where YY is a number from 00
through 29, Microsoft Access defaults to the years 2000 through 2029.
If you are using Microsoft Windows 95 or Microsoft Windows NT version 4.0, Access uses Oleaut32.dll to determine what century to use for dates when you do not specify all four digits.
If you are using Microsoft Windows 98 and you do not specify all four digits, Access determines what century to use based on the
When a two digit year is entered, interpret as a year between box setting in the
Regional Settings tool in Control Panel.
When you enter a date, type all four digits of the year. This will ensure
that the date will always be calculated the same way, no matter which version of Oleaut32.dll you have, or what the date range is set to in
Regional Settings in Control Panel.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate