topic Re: How to convert YYYYMM to MON YYYY in QlikView https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543149#M202971 <HTML><HEAD></HEAD><BODY><P>You could try</P><P></P><P><IMG alt="2013-10-10_2206.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/47503_2013-10-10_2206.png" /></P></BODY></HTML> Thu, 10 Oct 2013 21:16:38 GMT rustyfishbones 2013-10-10T21:16:38Z How to convert YYYYMM to MON YYYY https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543146#M202968 <HTML><HEAD></HEAD><BODY><P><BR />Hi All, I have CalMonth format like 201206,, and i would like to convert it to Jun 2012 or like Jun 12</P><P>Thanks</P></BODY></HTML> Thu, 10 Oct 2013 20:23:38 GMT https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543146#M202968 2013-10-10T20:23:38Z Re: How to convert YYYYMM to MON YYYY https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543147#M202969 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Try like this</P><P></P><P>=Date(Date#(201206,'YYYYMM'),'MMM YY') &lt;- Jun 12</P><P></P><P>=Date(Date#(201206,'YYYYMM'),'MMM YYYY') &lt;- Jun 2012</P><P></P><P>or</P><P></P><P>=Date(Date#(DateField,'YYYYMM'),'MMM YY')</P></BODY></HTML> Thu, 10 Oct 2013 20:31:16 GMT https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543147#M202969 MayilVahanan 2013-10-10T20:31:16Z Re: How to convert YYYYMM to MON YYYY https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543148#M202970 <HTML><HEAD></HEAD><BODY><P>Hello Faisal,</P><P></P><P>You can use the following:</P><P>Date(Date#(CalMonth, 'YYYYMM'), 'MMM YYYY')</P><P></P><P>Cheers,</P><P></P><P>Philippe</P></BODY></HTML> Thu, 10 Oct 2013 20:31:29 GMT https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543148#M202970 pgrenier 2013-10-10T20:31:29Z Re: How to convert YYYYMM to MON YYYY https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543149#M202971 <HTML><HEAD></HEAD><BODY><P>You could try</P><P></P><P><IMG alt="2013-10-10_2206.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/47503_2013-10-10_2206.png" /></P></BODY></HTML> Thu, 10 Oct 2013 21:16:38 GMT https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543149#M202971 rustyfishbones 2013-10-10T21:16:38Z Re: How to convert YYYYMM to MON YYYY https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543150#M202972 <HTML><HEAD></HEAD><BODY><P>Thanks All</P></BODY></HTML> Thu, 10 Oct 2013 21:52:28 GMT https://community.qlik.com/t5/QlikView/How-to-convert-YYYYMM-to-MON-YYYY/m-p/543150#M202972 2013-10-10T21:52:28Z