Forum Discussion
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
2 Replies
- MFelix
Super User
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
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!
