topic Re: Julian Date Conversion in QlikView https://community.qlik.com/t5/QlikView/Julian-Date-Conversion/m-p/162609#M36062 <HTML><HEAD></HEAD><BODY><P>Exist the function name is DayNumberOfYear</P></BODY></HTML> Wed, 12 Sep 2018 19:18:41 GMT beristardj 2018-09-12T19:18:41Z Julian Date Conversion https://community.qlik.com/t5/QlikView/Julian-Date-Conversion/m-p/162607#M36060 <HTML><HEAD></HEAD><BODY><P>Is there a built-in function or can one be created to convert from a Julian date to a recognizable date in QlikView?</P></BODY></HTML> Tue, 15 Mar 2011 20:44:32 GMT https://community.qlik.com/t5/QlikView/Julian-Date-Conversion/m-p/162607#M36060 2011-03-15T20:44:32Z Re: Julian Date Conversion https://community.qlik.com/t5/QlikView/Julian-Date-Conversion/m-p/162608#M36061 <HTML><HEAD></HEAD><BODY><P>LET CurrentJulian = 112333;</P><P></P><P>LET Gregorian_Date = date(yearstart(makedate(((($(CurrentJulian) - fmod($(CurrentJulian),1000)) / 1000) + 1900))) + (fmod($(CurrentJulian),1000) - 1));</P><P></P><P></P><P><STRONG style=": ; color: #00b400; font-size: 8pt;">No function exists that I know of but the code above works</STRONG></P></BODY></HTML> Fri, 30 Nov 2012 17:07:47 GMT https://community.qlik.com/t5/QlikView/Julian-Date-Conversion/m-p/162608#M36061 2012-11-30T17:07:47Z Re: Julian Date Conversion https://community.qlik.com/t5/QlikView/Julian-Date-Conversion/m-p/162609#M36062 <HTML><HEAD></HEAD><BODY><P>Exist the function name is DayNumberOfYear</P></BODY></HTML> Wed, 12 Sep 2018 19:18:41 GMT https://community.qlik.com/t5/QlikView/Julian-Date-Conversion/m-p/162609#M36062 beristardj 2018-09-12T19:18:41Z