Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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?

Tags (1)
2 Replies
Not applicable

Re: Julian Date Conversion

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
New Contributor III

Re: Julian Date Conversion

Exist the function name is DayNumberOfYear