Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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!
Solved! Go to 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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsThis 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!
User | Count |
---|---|
86 | |
82 | |
68 | |
67 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |