Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a built-in function or can one be created to convert from a Julian date to a recognizable date in QlikView?
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
Exist the function name is DayNumberOfYear