topic Re: how to convert month? in QlikView https://community.qlik.com/t5/QlikView/how-to-convert-month/m-p/82143#M788329 <HTML><HEAD></HEAD><BODY><P>load Month(Date#(Date,'YYYYMM')) as month</P></BODY></HTML> Fri, 09 Feb 2018 17:49:10 GMT shiveshsingh 2018-02-09T17:49:10Z how to convert month? https://community.qlik.com/t5/QlikView/how-to-convert-month/m-p/82141#M788327 <HTML><HEAD></HEAD><BODY><P>Hi </P><P>I have one date field like below.</P><P></P><P>Date</P><P>201701</P><P>201702</P><P>201703</P><P>.</P><P>.</P><P>.</P><P>.</P><P>201712</P><P></P><P>it showing like that i need creating the month field.in that i want show only months.</P><P></P><P>Thanks</P><P>daisy</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/how-to-convert-month/m-p/82141#M788327 daisy1438 2020-11-25T16:16:04Z Re: how to convert month? https://community.qlik.com/t5/QlikView/how-to-convert-month/m-p/82142#M788328 <HTML><HEAD></HEAD><BODY><P>num(right(Date,2)) as Month</P></BODY></HTML> Fri, 09 Feb 2018 17:39:34 GMT https://community.qlik.com/t5/QlikView/how-to-convert-month/m-p/82142#M788328 m_woolf 2018-02-09T17:39:34Z Re: how to convert month? https://community.qlik.com/t5/QlikView/how-to-convert-month/m-p/82143#M788329 <HTML><HEAD></HEAD><BODY><P>load Month(Date#(Date,'YYYYMM')) as month</P></BODY></HTML> Fri, 09 Feb 2018 17:49:10 GMT https://community.qlik.com/t5/QlikView/how-to-convert-month/m-p/82143#M788329 shiveshsingh 2018-02-09T17:49:10Z