Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Julian Date Conversion

Is there a built-in function or can one be created to convert from a Julian date to a recognizable date in QlikView?

2 Replies
Not applicable
Author

LET CurrentJulian = 112333;

LET Gregorian_Date = date(yearstart(makedate(((($(CurrentJulian) - fmod($(CurrentJulian),1000)) / 1000) + 1900))) + (fmod($(CurrentJulian),1000) - 1));

No function exists that I know of but the code above works

beristardj
Creator
Creator

Exist the function name is DayNumberOfYear