Results 1 to 7 of 7
  1. #1
    Join Date
    Apr 2002
    Location
    TX
    Posts
    34

    Question Unanswered: the infamous dates

    I am entering Dates of birth and if someone is born before 1930 then the date format recognizes it as 2029, i.e...

    Birthday Keystrokes Access Reads as
    1/1/1930 010130 1/1/1930
    1/1/1929 010129 1/1/2029
    1/1/1928 010128 1/1/2028

    Anyone know of a way to correct this?

  2. #2
    Join Date
    Mar 2002
    Location
    Bielefeld, Germany
    Posts
    69
    This is by design. For obvious reasons, with a two-digit-year, you have to define where the century should change. All versions off access above 2.0 do this at year 30.

    http://www.microsoft.com/office/ork/...our/67t4_2.htm

    shows how to adjust this (for Office2000).

    Using 4-digit-years corrects that as well ;-)

  3. #3
    Join Date
    Apr 2002
    Location
    TX
    Posts
    34
    How do I define a "4 digit year?

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    well, if *you* are entering the dates, just enter 4 digits for any year that's earlier than whatever the cutoff is

    it's as easy as that


  5. #5
    Join Date
    Apr 2002
    Location
    TX
    Posts
    34
    nope, it doesn't work that easy. Maybe it's in the format area? I have it set to "Short Date". I'll play with it. Thanks for your input.

  6. #6
    Join Date
    Jan 2003
    Location
    Dordrecht, The Netherlands
    Posts
    95
    Originally posted by legendv
    nope, it doesn't work that easy. Maybe it's in the format area? I have it set to "Short Date". I'll play with it. Thanks for your input.
    Also check the option "4-digit year number" (if this is the right translation from my Dutch Access-version) in Extra -> Options in Access.

  7. #7
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    228
    set your format string to something like

    mm/dd/yyyy (or rather dd.mm.yyyy if you are not in the us)

    important are the 4 y's.
    In a localized version of Access the formats might use different letters (at least when setting via the design editor), check your help file on formats.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •