I spent some considerable time investigating for any standard option to convert the date from JD Edwards (JDE) standard "CYYDDD" date format to the humanly recognizable Gregorian Date, but there seems to be no known function available out of the box.
For those who are new to the concept of JD Edwards date (like me), here is a brief intro.
In JDE, the format for Date is C-YY-DDD. (C for Century, YY for the two digit year and DDD for a number between 1 to 365 (or 366 for leap year)) Since JDE was invented in the 20th century (obviously), I believe they started this format which supports for only dates starting year 1900, (as I understand, JDE does not support dates before the year 1900).
Here are a few examples of JDE dates and their equivalent Gregorian date.
115141 - May 21, 2015
102317 - November 13, 2002
99054 - February 23, 1999
For those who are new to the concept of JD Edwards date (like me), here is a brief intro.
In JDE, the format for Date is C-YY-DDD. (C for Century, YY for the two digit year and DDD for a number between 1 to 365 (or 366 for leap year)) Since JDE was invented in the 20th century (obviously), I believe they started this format which supports for only dates starting year 1900, (as I understand, JDE does not support dates before the year 1900).
Here are a few examples of JDE dates and their equivalent Gregorian date.
115141 - May 21, 2015
102317 - November 13, 2002
99054 - February 23, 1999
