topic Month Extraction in QlikView https://community.qlik.com/t5/QlikView/Month-Extraction/m-p/511254#M191004 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to extract month (eg. Jan) info from a 012013 (monthyear field). Instead of getting 01 as the month output I would like to see Jan as the output from 012013.</P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 14 Jan 2014 23:04:15 GMT hkg_qlik 2014-01-14T23:04:15Z Month Extraction https://community.qlik.com/t5/QlikView/Month-Extraction/m-p/511254#M191004 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to extract month (eg. Jan) info from a 012013 (monthyear field). Instead of getting 01 as the month output I would like to see Jan as the output from 012013.</P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 14 Jan 2014 23:04:15 GMT https://community.qlik.com/t5/QlikView/Month-Extraction/m-p/511254#M191004 hkg_qlik 2014-01-14T23:04:15Z Re: Month Extraction https://community.qlik.com/t5/QlikView/Month-Extraction/m-p/511255#M191005 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>You can try to use MakeDate:</P><P></P><P>Date(MakeDate(Right('012013',4),Left('012013',2))) as Date,</P><P>Month(Date(MakeDate(Right('012013',4),Left('012013',2)))) as Month,</P><P></P><P>something like this:</P><P></P><P>Date(MakeDate(Right(MyField,4),Left(MyField,2))) as Date,</P><P>Month(Date(MakeDate(Right(MyField,4),Left(MyField,2)))) as Month,</P><P></P><P>Best regards.</P></BODY></HTML> Tue, 14 Jan 2014 23:10:19 GMT https://community.qlik.com/t5/QlikView/Month-Extraction/m-p/511255#M191005 2014-01-14T23:10:19Z Re: Month Extraction https://community.qlik.com/t5/QlikView/Month-Extraction/m-p/511256#M191006 <HTML><HEAD></HEAD><BODY><P>Use this ....</P><P>=month(MakeDate(right('012013',4),left('012013',2)))</P><P></P><P>Replace 012013 with your MonthYear field..</P></BODY></HTML> Tue, 14 Jan 2014 23:17:53 GMT https://community.qlik.com/t5/QlikView/Month-Extraction/m-p/511256#M191006 phaneendra_kunc 2014-01-14T23:17:53Z