Date to JDEdwards Julian Date !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
632265Jun 18 2008 — edited Jan 18 2012Hi,
How can I convert a Date to JDE Date,
I used this syntax to convert to a Julian date in torks fine.
TO_NUMBER(TO_CHAR( SYSDATE,'J'))
But in Jd Edwards ERP the date format is stored in an Different format.
Example:
Normal Date :18-Jun-2008
Julian Date value : 2454635.50000
JDE Julian Date Convertor : 108170
For this Julian Date you can have a look into this link also
http://peoplesoft.macek.cc/dateconverter.php?
Expected Output :
Normal Date :18-Jun-2008
JDE Julian Date Convertor : 108170
How can i achieve this ...?
Thanks
AK
Message was edited by:
Ananda