topic Re: date form in QlikView https://community.qlik.com/t5/QlikView/date-form/m-p/1314402#M843321 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>=Date(42467,'which ever date format you want')</P></BODY></HTML> Thu, 13 Apr 2017 11:46:11 GMT Anonymous 2017-04-13T11:46:11Z date form https://community.qlik.com/t5/QlikView/date-form/m-p/1314400#M843319 <HTML><HEAD></HEAD><BODY><P>Hey all</P><P></P><P>any idea if I want to Transfrom</P><P></P><P>number to date form example :</P><P></P><P>"42467" should look like this : "20160407".</P><P></P><P>Thank you,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/date-form/m-p/1314400#M843319 mario-sarkis 2020-11-25T16:16:04Z Re: date form https://community.qlik.com/t5/QlikView/date-form/m-p/1314401#M843320 <HTML><HEAD></HEAD><BODY><P>Hello Mario,</P><P></P><P>Please use below:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_macro_code jive_text_macro _jivemacro_uid_1492083732194363" jivemacro_uid="_1492083732194363" modifiedtitle="true"> <P><SPAN style="font-size: 13.3333px;">=Date(42467, 'YYYYMMDD')</SPAN></P> </PRE><P></P><P>Hope this will be of help.</P><P></P><P>Regards!</P><P>Rahul</P></BODY></HTML> Thu, 13 Apr 2017 11:43:04 GMT https://community.qlik.com/t5/QlikView/date-form/m-p/1314401#M843320 rahulpawarb 2017-04-13T11:43:04Z Re: date form https://community.qlik.com/t5/QlikView/date-form/m-p/1314402#M843321 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>=Date(42467,'which ever date format you want')</P></BODY></HTML> Thu, 13 Apr 2017 11:46:11 GMT https://community.qlik.com/t5/QlikView/date-form/m-p/1314402#M843321 Anonymous 2017-04-13T11:46:11Z