Forum Discussion
Solved
Convert Julian Date to Calendar Date
I am pulling in a date column from JDE and need to convert a Julian date (CYYDDD) to a calendar date. Is there a good way to do this? Thank you!
Hi jksmith17,
I'm also making some SQL from JDE and used the query editor to make an additional column use the following code:
Date = #date(1900+Number.IntegerDivide([JULIEN_DATE], 1000),1,1)+#duration(Number.Mod([JULIEN_DATE], 1000)-1,0,0,0)
The Date is the column name I gave and the JULIEN_DATE is the column name change it to what fit's your model.
Regards,
MFelix
MFelix
Super User
Super UserHi jksmith17,
I'm also making some SQL from JDE and used the query editor to make an additional column use the following code:
Date = #date(1900+Number.IntegerDivide([JULIEN_DATE], 1000),1,1)+#duration(Number.Mod([JULIEN_DATE], 1000)-1,0,0,0)
The Date is the column name I gave and the JULIEN_DATE is the column name change it to what fit's your model.
Regards,
MFelix
This worked! Thank you! I had tried some other variations of formulas, but they didn't quite work. I think the CYYDDD format was throwing them off. Thanks again for your help!
