Julian Dates - Web Intel

DamCPU

Active Member
Has anyone converted JD Edwards DB2 Julian in (Crystal XI R2 Universes) to mm/dd/yyyy.

thanks in advance
 
We use the ODA drivers that come with JDE. They automatically do the date conversions for you.

However, if you do search in the Developer's forum you can find several postings about how to do the date conversions.
 
This is the correct formula to use with Universes (webi)
AS400R2

Object Type:

DATE({fn concat('01/01/',{fn floor(PRODDTA.F0911.GLDGJ/1000)}+1900))} +(PRODDTA.F0911.GLDGJ- (Floor(PRODDTA.F0911.GLDGJ/1000)*1000)-1) DAYS

Julian

101120

Return

04/30/01

If Date is NULL or 0 returns

12/31/99
 
Back
Top