topic Date/String Conversion in QlikView https://community.qlik.com/t5/QlikView/Date-String-Conversion/m-p/513135#M1130827 <HTML><HEAD></HEAD><BODY><P>I have field in the QVD YearMonth and the format is YYYYMM. In the line chart I want to display this dimension as MON-YY.</P><P>What is the best possible way?</P></BODY></HTML> Tue, 12 Nov 2013 14:16:56 GMT 2013-11-12T14:16:56Z Date/String Conversion https://community.qlik.com/t5/QlikView/Date-String-Conversion/m-p/513135#M1130827 <HTML><HEAD></HEAD><BODY><P>I have field in the QVD YearMonth and the format is YYYYMM. In the line chart I want to display this dimension as MON-YY.</P><P>What is the best possible way?</P></BODY></HTML> Tue, 12 Nov 2013 14:16:56 GMT https://community.qlik.com/t5/QlikView/Date-String-Conversion/m-p/513135#M1130827 2013-11-12T14:16:56Z Re: Date/String Conversion https://community.qlik.com/t5/QlikView/Date-String-Conversion/m-p/513136#M1130829 <HTML><HEAD></HEAD><BODY><P><STRONG>Piyush</STRONG></P><P></P><P>Assuming your field is a text field then try :</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; date( date#([yourfield],'YYYYMM') ,'MMM-YY')</P><P></P><P></P><P>Best Regards,&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>Bill</STRONG></P></BODY></HTML> Tue, 12 Nov 2013 14:20:47 GMT https://community.qlik.com/t5/QlikView/Date-String-Conversion/m-p/513136#M1130829 Anonymous 2013-11-12T14:20:47Z Re: Date/String Conversion https://community.qlik.com/t5/QlikView/Date-String-Conversion/m-p/513137#M1130831 <HTML><HEAD></HEAD><BODY><P>Thank you. It worked.</P></BODY></HTML> Tue, 12 Nov 2013 14:23:50 GMT https://community.qlik.com/t5/QlikView/Date-String-Conversion/m-p/513137#M1130831 2013-11-12T14:23:50Z