Results 1 to 3 of 3
  1. #1
    Frank_7 is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jul 2019
    Posts
    1

    Unhappy Access is converting DOB's in the 1920's, 1930's, and 1940's to a future date

    I am using Access from Office 365 to administer a Defensive Driving Database. We enter personal info from the student, DL, DOB, address, etc. We enter DOB by typing the month, date, and last two digits of the year so 6/21/1946 would be entered 6/21/46. For some unexplained reason when I am entering DOB's for people born in the 1920's, 1930's, and 1940's the year birthdate is shown as 20xx. For example, if I type DOB as 6/21/46 and hit Enter the DOB is shown as 6/21/2046. 6/26/22 becomes 6/26/2022, and 6/26/32 becomes 6/26/2032. For people born in the 50's, 60's, 70's, etc this problem doesn't occur. 6/26/46 becomes 6/26/1946. I have tried repairing Access, uninstalling and reinstalling Access with no success. My son living in another household has the database as well but has no problems as I have described above. Any ideas of what's going on? Recommendations or suggestions to fix? Oh yes, when I using Access 2003 and Access2010 the same problem occurred.



    Frank
    El Paso, Texas

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I am using Access 2010. My db presumes 20xx through 2029. When I enter 30 it returns 1930. This is when entering directly into table. Textbox on form uses InputMask to force 20xx (not entering birthdates).

    Enter year as 4-digits to remove ambiguity.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    As to WHY this happens, see https://support.office.com/en-us/art...A-93F2B046F503

    Two-digit years for the year argument are interpreted based on user-defined machine settings.
    The default settings are that values between 0 and 29, inclusive, are interpreted as the years 2000–2029.
    The default values between 30 and 99 are interpreted as the years 1930–1999.
    For all other year arguments, use a four-digit year (for example, 1800).
    Windows versions earlier than Windows 2000 interpret two-digit years based on the defaults described above. To be sure the function returns the proper value, use a four-digit year.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Future date calculations
    By ACu in forum Access
    Replies: 2
    Last Post: 05-02-2019, 09:12 PM
  2. Replies: 3
    Last Post: 02-24-2019, 02:35 PM
  3. Future Date that may be incremented
    By h1mself2 in forum Access
    Replies: 3
    Last Post: 12-14-2012, 04:11 PM
  4. Replies: 3
    Last Post: 11-20-2012, 01:40 PM
  5. Future date parameter
    By normie in forum Queries
    Replies: 10
    Last Post: 08-12-2010, 09:38 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums