Thread: JDEdwards date
View Single Post

   
  #6 (permalink)  
Old 02-27-2008, 08:26 AM
no_spam_for_gman
 
Posts: n/a
Default 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)))

Reply With Quote