Re: JDEdwards date
I did managed to easily create the function to go back and forth. I
will provide it in case someone is looking for the logic.....
DATE to JDE Date (using DB2's current_date):
----------------------------------------------------------
DECIMAL((YEAR(current_date)-1900)*1000+DAYOFYEAR(current_date),6)
JDE Date to DATE:
------------------------
DATE(DIGITS(DECIMAL(JDE_DATE_FIELD + 1900000,7,0))) |