Date field default year 1930 instead of 2030

SOLVED

Have recently found in both V11 and V12 that when enter date manually '10/30/30' the date is actually entered as 10/30/1930 and not 10/30/2030.  

I found this for the expiration date or SHLDAT field which uses a D data type.   If enter 10/30/29 the default year is 2029.

Would anyone know how to resolve this?  Even if the display of the field was mm/dd/yyyy it would still need to be changed.

thanks

Christine

Parents
  • +1
    verified answer

    Try setting the two digit max year in locale preferences.

    This is called the rollover date and it was a popular topic around the changing of the millennium.   

    adxdcs is a pivot year used to determine the century when the year is two digits.

    Upper and lower bound

    You need to provide a pivot date to define the century used by default when the date is two digits. Only the upper bound is entered, the lower bound is calculated accordingly.

    Example: If you enter 2029 for the upper bound:

    • Any date with a year that has two digits lower or equal to 29 is in the [2000-2029] range.
    • Any date with a year that has two digits between 30 and 99 is in the [1930-1999] range, which is the reason why 1930 > is displayed in the lower bound.

  • 0 in reply to Stephen

    hi- i'm looking at the locale and see the two digit max year but I don't understand when you say upper bound and lower bound.  So what do I adjust so I can have the year default to 2030?  thanks

  • 0 in reply to Christine T.
    SUGGESTED

    Just set the pivot year to 2050.   As long as you have no data in the system with 2 digits years prior to 1950 it will then start "pivoting" on 2050.   Birthdays can be a problem because folks born in 1949 with a 2 digit year entered would be born in 2049 but you would think that programmers would use a 4 digit year anywhere that exist. 

    So editing the discussion above

    Example: If you enter 2050 for the upper bound:

    • Any date with a year that has two digits lower or equal to 50 is in the [2000-2050] range.
    • Any date with a year that has two digits between 50 and 99 is in the [1950-1999] range
Reply
  • 0 in reply to Christine T.
    SUGGESTED

    Just set the pivot year to 2050.   As long as you have no data in the system with 2 digits years prior to 1950 it will then start "pivoting" on 2050.   Birthdays can be a problem because folks born in 1949 with a 2 digit year entered would be born in 2049 but you would think that programmers would use a 4 digit year anywhere that exist. 

    So editing the discussion above

    Example: If you enter 2050 for the upper bound:

    • Any date with a year that has two digits lower or equal to 50 is in the [2000-2050] range.
    • Any date with a year that has two digits between 50 and 99 is in the [1950-1999] range
Children