Changing the Century for Calendar or Defaults for Effective dates

The maximum value of Effective Thru (EFFT) date (as in some fields, like BOM Effective Date, Lot Effective Date, Etc …) the default value is 2010/12/31

Similarly, when you key in the dates like 06/20/11, the dates will automatically default to 06/20/1911, which is absurd.

Now you can change it via two data dictionary items – Century Change Year (CENTCHG) and DCYR.  Set it’s default value to 30 or 40, 50. The Effective Thru Date can be to 2030/12/31, 2040/12/31, 2050/12/31, its default value is 2010/12/31.

But make sure that You deploy to get the changes effective.

Related posts:

1. Calculate Begin and End Dates for Month/Year
2. Change Database values using MS Access (JDE E1 Oracle)
3. Convert Julian Date to Gregorian Date (SQL)
4. Gandhiji’s top 10 fundamentals on Change & Evolution
5. Change FileNames in Table Conversion or Business View in UBE