DamCPU Active Member May 1, 2006 #1 Has anyone converted JD Edwards DB2 Julian in (Crystal XI R2 Universes) to mm/dd/yyyy. thanks in advance
Has anyone converted JD Edwards DB2 Julian in (Crystal XI R2 Universes) to mm/dd/yyyy. thanks in advance
eydeak VIP Member May 15, 2006 #2 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.
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.
yeokh Member May 17, 2006 #3 Refer to Tip # 534; Improving Report Processing Time at: http://preferredstrategies.com/newsletters/20041003.html For example, create a formula field: Dateserial((int({F0101.ABUPMJ}/1000)+1900),1,{F0101.ABUPMJ} mod 1000)
Refer to Tip # 534; Improving Report Processing Time at: http://preferredstrategies.com/newsletters/20041003.html For example, create a formula field: Dateserial((int({F0101.ABUPMJ}/1000)+1900),1,{F0101.ABUPMJ} mod 1000)
DamCPU Active Member Oct 11, 2006 #4 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
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