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
Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
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
pludlow's avatar
pludlow
Helper I
8 years ago

HI, when I try this formula, I am getting a Token Eof expected error

  • pludlow's avatar
    pludlow
    Helper I
    8 years ago

    I was able to solve my issue using the formula I used above but reformatting the date

  • pludlow's avatar
    pludlow
    Helper I
    8 years ago

    Hi jpt1228, still confused.  I am pulling data straight of JDE and coming out in this format.  I have tried several formulas and

     

    none seem to work.  Below is the best one so far