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
parry2k's avatar
parry2k
Super User
8 years ago

well easier to add julian date in calendar table and set relationship on julian date between date and inventory table.

 

It can be handly to have in date table , in case you hve another table with julian dte, you don't need to convert it to date rather use julian date.