topic Re: Datefield MonthYear in QlikView https://community.qlik.com/t5/QlikView/Datefield-MonthYear/m-p/917967#M318240 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Date(Date#(Date,'YYYYMM'),'YYYY-MMM') as Month</STRONG></SPAN></P></BODY></HTML> Tue, 28 Jul 2015 13:12:25 GMT sunny_talwar 2015-07-28T13:12:25Z Datefield MonthYear https://community.qlik.com/t5/QlikView/Datefield-MonthYear/m-p/917966#M318239 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I'm loading monthly data witht the below date format, however I would like to convert it to 'YYYY-MMM'</P><P></P><P>201501</P><P>201502</P><P>201503</P><P><BR />I tried the below but it results in null values.</P><P></P><P>DATE(Date,'YYYY-MMM') as Month</P></BODY></HTML> Tue, 28 Jul 2015 13:11:16 GMT https://community.qlik.com/t5/QlikView/Datefield-MonthYear/m-p/917966#M318239 2015-07-28T13:11:16Z Re: Datefield MonthYear https://community.qlik.com/t5/QlikView/Datefield-MonthYear/m-p/917967#M318240 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><STRONG>Date(Date#(Date,'YYYYMM'),'YYYY-MMM') as Month</STRONG></SPAN></P></BODY></HTML> Tue, 28 Jul 2015 13:12:25 GMT https://community.qlik.com/t5/QlikView/Datefield-MonthYear/m-p/917967#M318240 sunny_talwar 2015-07-28T13:12:25Z