topic Re: Converting Persian date which are stored in Integer format to Gregorian date in QlikView https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216099#M389467 <HTML><HEAD></HEAD><BODY><P>That was very useful. Thank you.</P></BODY></HTML> Mon, 06 Feb 2017 21:37:07 GMT 2017-02-06T21:37:07Z Converting Persian date which are stored in Integer format to Gregorian date https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216097#M389465 <HTML><HEAD></HEAD><BODY><P>Hi </P><P></P><P></P><P>I have a sql database with Persian dates which are stored as Integer format e.g. 13950629. I would like to convert this to Gregorian date so that I can perform various operation such as finding the difference between 2 dates in days and months. I have already seen the following thread which converts the <SPAN style="font-size: 13.3333px;">Gregorian </SPAN>dates to Iranian dates. My question is that how do I convert a integer into the correct format so I can join to the "<A _jive_internal="true" href="https://community.qlik.com/servlet/JiveServlet/download/521676-104866/persian_date.tsv.zip" style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3778c7; background-color: #fdfdfd;">persian_date.tsv.zip</A>"?</P><P></P><P><A href="https://community.qlik.com/thread/117104">How can sort special format date in search object's results?</A></P><P></P><P>Any suggestion are greatly appreciated.</P><P></P><P>Kind regards,</P><P>Farshid</P></BODY></HTML> Sun, 05 Feb 2017 19:47:01 GMT https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216097#M389465 2017-02-05T19:47:01Z Re: Converting Persian date which are stored in Integer format to Gregorian date https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216098#M389466 <HTML><HEAD></HEAD><BODY><P>Look at this thread:</P><P><A href="https://community.qlik.com/qlik-blogpost/4898">Non-Gregorian calendars</A></P></BODY></HTML> Sun, 05 Feb 2017 22:16:47 GMT https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216098#M389466 sunny_talwar 2017-02-05T22:16:47Z Re: Converting Persian date which are stored in Integer format to Gregorian date https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216099#M389467 <HTML><HEAD></HEAD><BODY><P>That was very useful. Thank you.</P></BODY></HTML> Mon, 06 Feb 2017 21:37:07 GMT https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216099#M389467 2017-02-06T21:37:07Z Re: Converting Persian date which are stored in Integer format to Gregorian date https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216100#M389468 <HTML><HEAD></HEAD><BODY><P>No problem <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 06 Feb 2017 21:52:43 GMT https://community.qlik.com/t5/QlikView/Converting-Persian-date-which-are-stored-in-Integer-format-to/m-p/1216100#M389468 sunny_talwar 2017-02-06T21:52:43Z