topic Re: Date Conversion in QlikView https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130927#M371763 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>MonthName(Alt(Date#(DateField, 'D-M-YYYY'), Date#(DateField, 'YYYY/MMM'))) as MonthYear</STRONG></P></BODY></HTML> Mon, 11 Jul 2016 14:01:55 GMT sunny_talwar 2016-07-11T14:01:55Z Date Conversion https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130926#M371762 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have dates in the following format:</P><P></P><P>1-1-2016</P><P>2-1-2016</P><P>3-1-2016</P><P>2016/April,</P><P>2016/May</P><P></P><P>Now I want to convert this into Month Year (i.e. May 2016).</P><P></P><P>Can anyone help me with this?</P><P></P><P>Thanks in advance!</P><P></P><P>Regards,</P><P>Varun</P></BODY></HTML> Mon, 11 Jul 2016 13:58:26 GMT https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130926#M371762 varunreddy 2016-07-11T13:58:26Z Re: Date Conversion https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130927#M371763 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>MonthName(Alt(Date#(DateField, 'D-M-YYYY'), Date#(DateField, 'YYYY/MMM'))) as MonthYear</STRONG></P></BODY></HTML> Mon, 11 Jul 2016 14:01:55 GMT https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130927#M371763 sunny_talwar 2016-07-11T14:01:55Z Re: Date Conversion https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130928#M371764 <HTML><HEAD></HEAD><BODY><P>Sunny this equation is displaying dates with the format May/2016.</P><P></P><P>It is not displaying dates with 1/1/2016</P></BODY></HTML> Mon, 11 Jul 2016 14:05:55 GMT https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130928#M371764 varunreddy 2016-07-11T14:05:55Z Re: Date Conversion https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130929#M371765 <HTML><HEAD></HEAD><BODY><P>Sunny,</P><P></P><P>Got it.</P><P></P><P>Thanks for the quick response.</P><P></P><P>Cheers,</P><P>Varun</P></BODY></HTML> Mon, 11 Jul 2016 14:09:26 GMT https://community.qlik.com/t5/QlikView/Date-Conversion/m-p/1130929#M371765 varunreddy 2016-07-11T14:09:26Z