topic MONTH FORMAT in QlikView https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714379#M257088 <HTML><HEAD></HEAD><BODY><P>hi ,</P><P></P><P>i wnat to extract&nbsp; month from </P><P></P><P>MMM YYYY </P><P></P><P>format .</P><P></P><P>what should i do ?</P></BODY></HTML> Fri, 04 Jul 2014 10:35:18 GMT 2014-07-04T10:35:18Z MONTH FORMAT https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714379#M257088 <HTML><HEAD></HEAD><BODY><P>hi ,</P><P></P><P>i wnat to extract&nbsp; month from </P><P></P><P>MMM YYYY </P><P></P><P>format .</P><P></P><P>what should i do ?</P></BODY></HTML> Fri, 04 Jul 2014 10:35:18 GMT https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714379#M257088 2014-07-04T10:35:18Z Re: MONTH FORMAT https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714380#M257089 <HTML><HEAD></HEAD><BODY><P>Write like</P><P></P><P>Month(YourDateField) //You get Jan, Feb</P><P></P><P>If you need 01,02,03,04 then write like</P><P></P><P>Date(YourDateField,'MM') as Month</P><P></P><P>Or</P><P></P><P>Date(YourDateField,'MM')</P><P></P><P>Or</P><P></P><P>Date(Date#(Left(YourDateField,3),'MMM'),'MM')</P></BODY></HTML> Fri, 04 Jul 2014 10:39:45 GMT https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714380#M257089 its_anandrjs 2014-07-04T10:39:45Z Re: MONTH FORMAT https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714381#M257090 <HTML><HEAD></HEAD><BODY><P>Month(Date#(YourData, 'MMM YYYY')) as Month</P></BODY></HTML> Fri, 04 Jul 2014 10:49:58 GMT https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714381#M257090 tresB 2014-07-04T10:49:58Z Re: MONTH FORMAT https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714382#M257091 <HTML><HEAD></HEAD><BODY><P>left('MMMYYYY',3) as month</P></BODY></HTML> Fri, 04 Jul 2014 10:53:28 GMT https://community.qlik.com/t5/QlikView/MONTH-FORMAT/m-p/714382#M257091 2014-07-04T10:53:28Z