Access automatically converts any value under 100. ie: 0099 converts to 1999 and 0010 to 2010 and 0001 to 2001.
Is there any w开发者_开发知识库ay around this problem or is it not possible to save dates in Access so far away?
Access won't let you store dates earlier than 1/1/100 AD.
Of course, you could always just store an integer for the year and do your own date handling.
精彩评论