Re: Converting JDE Julian Dates into something more readable .

Re: Converting JDE Julian Dates into something more readable .

Kenny,
I use this formula in MS Access to convert the JDE Julian to a date value
where IREFFF is the field in JDE that has the JDE Julian, (in this instance
this is the Effective From date in the F3003 file.)

DateValue("12/31/" & (Int([IrEFFF]/1000))+1899)+([irefff]-Int
([irefff]/1000)*1000)

Here's how it would look in MS Excel

=DATEVALUE("12/31/" & (INT(B1/1000))+1899)+(B1-INT(B1/1000)*1000)
where cell B1 has the JDE Jullian Date.

Good Luck!
Hal McGee