Convert Julian Date to Calendar Date

[jksmith17]

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!

[MFelix · Accepted solution]

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

[jksmith17]

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!