Forum Discussion

jpt1228's avatar
jpt1228
Responsive Resident
8 years ago
Solved

Julian Date Conversion or Format

Hello, I searched and read the 2 posts about julian dating but I can't get a solution to work.   I can either convert the julian date column on my inventory table YYDDD into a calendar date or add ...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Sorry, my mistake.

     

    Please use this instead

     

    Column = 
VAR myYear = 2000 + INT(DIVIDE([Julian Manufacture Date],1000))
VAR myDayOfYear = MOD([Julian Manufacture Date],1000) -1
RETURN DATE( myYear,1,1) + myDayOfYear
Anonymous's avatar
Anonymous
Not applicable
6 years ago

I'm converting Julian dates in JD Edwards (Oracle DB), and I had to add "1900" to the year portion of the formula.  So this is the working Power Query (M) formula I wound up with:

 

Date.AddDays( #date(Number.RoundDown([Julian Date]/1000)+1900, 1,1), Number.Mod([Julian Date], 1000)-1))