topic Re: String or Number to Date Format in QlikView https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476643#M694136 <HTML><HEAD></HEAD><BODY><P>Selva,</P><P></P><P>See the attached file .</P><P>I have done a logical change and scripting in script of the qvw.</P><P></P><P></P><P></P><P>Hope it help you,</P></BODY></HTML> Mon, 17 Jun 2013 08:37:18 GMT sujeetsingh 2013-06-17T08:37:18Z String or Number to Date Format https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476639#M694132 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I need to convert " 200011" to Year and Month Format like this " Nov&nbsp; 2000".</P><P></P><P>I tried this </P><P><SPAN style="font-size: 8pt;">&nbsp; </SPAN></P><P><SPAN style="font-size: 8pt;"><SPAN style=": ; font-size: 1;"></SPAN></SPAN></P><P>=</P><SPAN style="color: #0000ff; font-size: 8pt;">Date# </SPAN><SPAN style="font-size: 8pt;">(01012001, 'MMM YYYY') </SPAN><P></P><P></P><P>but it not working. Is there any way to do this.</P><P></P><P></P><P>Thanks,</P><P>Selva</P></BODY></HTML> Mon, 17 Jun 2013 08:26:47 GMT https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476639#M694132 2013-06-17T08:26:47Z Re: String or Number to Date Format https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476640#M694133 <HTML><HEAD></HEAD><BODY><P>Try date(date#('200011','YYYYMM'),'MMM YYYY')</P></BODY></HTML> Mon, 17 Jun 2013 08:31:15 GMT https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476640#M694133 Gysbert_Wassenaar 2013-06-17T08:31:15Z Re: String or Number to Date Format https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476641#M694134 <HTML><HEAD></HEAD><BODY><P>try this</P><P><STRONG>date(DATE#('200011','YYYYMM'),'MMM YYYY')</STRONG></P></BODY></HTML> Mon, 17 Jun 2013 08:31:24 GMT https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476641#M694134 2013-06-17T08:31:24Z Re: String or Number to Date Format https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476642#M694135 <HTML><HEAD></HEAD><BODY><P>You need to use date#() to convert the string into a date and than use date() get the desired format:</P><P></P><PRE __default_attr="sql" __jive_macro_name="code" class="jive_text_macro jive_macro_code _jivemacro_uid_13714579852781313" jivemacro_uid="_13714579852781313"><P>date(date#(200011,'YYYYMM'),'MMM YYYY')</P></PRE><P></P><P>Also see the examples in the Qlikview Manual ...</P><P>Hope that helps!</P><P></P><P>Regards, </P><P>Florian</P></BODY></HTML> Mon, 17 Jun 2013 08:35:09 GMT https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476642#M694135 pennetzdorfer 2013-06-17T08:35:09Z Re: String or Number to Date Format https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476643#M694136 <HTML><HEAD></HEAD><BODY><P>Selva,</P><P></P><P>See the attached file .</P><P>I have done a logical change and scripting in script of the qvw.</P><P></P><P></P><P></P><P>Hope it help you,</P></BODY></HTML> Mon, 17 Jun 2013 08:37:18 GMT https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476643#M694136 sujeetsingh 2013-06-17T08:37:18Z Re: String or Number to Date Format https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476644#M694137 <HTML><HEAD></HEAD><BODY><P>You may also find this link usefull (I know did) <A _jive_internal="true" class="loading" href="https://community.qlik.com/docs/DOC-3102">http://community.qlik.com/docs/DOC-3102</A></P></BODY></HTML> Mon, 17 Jun 2013 10:38:16 GMT https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476644#M694137 RedSky001 2013-06-17T10:38:16Z Re: String or Number to Date Format https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476645#M694138 <HTML><HEAD></HEAD><BODY><P>Thankyou all.. Everyone on the same line...</P></BODY></HTML> Mon, 17 Jun 2013 10:54:55 GMT https://community.qlik.com/t5/QlikView/String-or-Number-to-Date-Format/m-p/476645#M694138 2013-06-17T10:54:55Z