Conversion of Julian Dates in Oracle

[#1]

I am extracting data from an Oracle database (JDE) and the dates are in Julian format. How can I convert this date field to reflect the Gregorian (normal) date format. Thanks for any assistance.

[sergio0592]

So, it works with :

=date(yearstart(date#(left([Julian Date],1)+19&mid([Julian Date],2,2),'YYYY'))+(right([Julian Date],3)-1),'DD/MM/YYYY')

[zhadrakas]

this could be helpful

Oracle Julian Date Conversion