Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Conversion of Julian Dates in Oracle

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.

2 Replies
sergio0592
Specialist III
Specialist III

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
Specialist II
Specialist II

this could be helpful

Oracle Julian Date Conversion