topic Re: Convertion of Date format in QlikView https://community.qlik.com/t5/QlikView/Convertion-of-Date-format/m-p/717351#M1074416 <HTML><HEAD></HEAD><BODY><P>Date(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateField,'YYYYMM'),'MMM YY') as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateField</SPAN></SPAN></P></BODY></HTML> Tue, 05 Aug 2014 15:19:49 GMT MK_QSL 2014-08-05T15:19:49Z Convertion of Date format https://community.qlik.com/t5/QlikView/Convertion-of-Date-format/m-p/717350#M1074415 <HTML><HEAD></HEAD><BODY><P><BR />hello QV,</P><P></P><P>I have a data field like 201405,201406(YYYYMM) format,I wan to convert it to May 14,Jun 14,</P><P></P><P>will this help??</P><P><SPAN style="color: #008000; font-size: 8pt;">&nbsp; </SPAN></P><P>Date(Date#(FISCAL_YEAR_MONTH_NUM,YYYYMM),MMMYY) as FiscalMonth</P><P></P><P></P><P>Thanks</P><P></P></BODY></HTML> Tue, 05 Aug 2014 15:14:22 GMT https://community.qlik.com/t5/QlikView/Convertion-of-Date-format/m-p/717350#M1074415 2014-08-05T15:14:22Z Re: Convertion of Date format https://community.qlik.com/t5/QlikView/Convertion-of-Date-format/m-p/717351#M1074416 <HTML><HEAD></HEAD><BODY><P>Date(Date#(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateField,'YYYYMM'),'MMM YY') as <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">DateField</SPAN></SPAN></P></BODY></HTML> Tue, 05 Aug 2014 15:19:49 GMT https://community.qlik.com/t5/QlikView/Convertion-of-Date-format/m-p/717351#M1074416 MK_QSL 2014-08-05T15:19:49Z