Converting Julian Dates to Gregorian Dates

[Former Member]

<p>We are using JD Edwards and I am building a Universe against some of its data. The problem I am running into deals with converting Julian Dates to Standard Dates as part of the Universe Design. There seem to only be a limited number of functions in the universe designers function builder. </p><p> JDE would store January 1, 2007 as 107001. </p><p>Please let me know the best way to facilitate the conversion.</p>

[Former Member]

Hello, we have created direct connect universes for JDE many times over the years. The answer to your question depends on the JDE database you are connecting to. If the database is SQL Server then try this: select DATEADD(day,CONVERT(int,F0911.GLDGJ) - ((1000*(CONVERT(int,F0911.GLDGJ)/1000))) - 1, DATEADD(year,CONVERT(int,F0911.GLDGJ/1000), '1 Jan 1900')). If the database is DB2/400 on iSeries then try this: DATE ( DIGITS (DECIMAL (F0911.GLDGJ+1900000,7,0) ) ).

Let me know if this works for you.

[Former Member]

Hi Joe,

Can you please tell me where you managed to discover this from? I am really impressed with this solution... The julian to gregorian conversion is a real pain for JDE users. Congratulations!

Manish

[Former Member]

Manish

You could look at http://www.itjungle.com/mgo/mgo090602-story01.html for relevant information.

[Former Member]

Thanks!

[Former Member]

Rgds,

Manish

http://www.dcs.bbk.ac.uk/~ldana01/

[Former Member]

http://www.dcs.bbk.ac.uk/~ldana01/