Forum Discussion
Solved
7 Digit Julian Date conversion
Hellowive looked for an answer regarding this but only ones regarding different julian forms. I have a date field from our 400 server thats in 7 digit date format. Example: 2016005 That emaple ...
If a query (M) solution is also fine, then you can add a custom column with the following code, in which "JulianDate" is your field with the 7-digit date:
= Date.AddDays(#date(Number.RoundDown([JulianDate]/1000),1,1),Number.Mod([JulianDate],1000)-1)
Thanks everyone . MarcelBeug Your version worked perfect!