topic Re: Month format in QlikView https://community.qlik.com/t5/QlikView/Month-format/m-p/53568#M774489 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Try this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(Date#(Month_Field, 'M') ,'MM')</P><P>Regards</P><P>Vamsee</P></BODY></HTML> Fri, 04 May 2018 19:05:45 GMT vamsee 2018-05-04T19:05:45Z Month format https://community.qlik.com/t5/QlikView/Month-format/m-p/53564#M774485 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>I am having Month filed having the data </P><P></P><P>1,2,3,4,5,6,7,8,9,10,11,12</P><P>but i want the output like</P><P>01,02,03,04,05,06,07,08,09,10,11</P><P></P><P>can you please help me on the same?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Month-format/m-p/53564#M774485 Anonymous 2020-11-25T16:16:04Z Re: Month format https://community.qlik.com/t5/QlikView/Month-format/m-p/53565#M774486 <HTML><HEAD></HEAD><BODY><P>May be try</P><P>Date(MakeDate(2018.yourMonth),'MM')</P></BODY></HTML> Fri, 04 May 2018 10:29:12 GMT https://community.qlik.com/t5/QlikView/Month-format/m-p/53565#M774486 sasiparupudi1 2018-05-04T10:29:12Z Re: Month format https://community.qlik.com/t5/QlikView/Month-format/m-p/53566#M774487 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>use this</P><P>=if(len(Month&lt;=1),'0' &amp; Month,Month)</P></BODY></HTML> Fri, 04 May 2018 10:52:16 GMT https://community.qlik.com/t5/QlikView/Month-format/m-p/53566#M774487 sudhirpkuwar 2018-05-04T10:52:16Z Re: Month format https://community.qlik.com/t5/QlikView/Month-format/m-p/53567#M774488 <HTML><HEAD></HEAD><BODY><P>TIMESTAMP([YOURMONTH],'MM')</P></BODY></HTML> Fri, 04 May 2018 18:16:52 GMT https://community.qlik.com/t5/QlikView/Month-format/m-p/53567#M774488 eduardo_dimperio 2018-05-04T18:16:52Z Re: Month format https://community.qlik.com/t5/QlikView/Month-format/m-p/53568#M774489 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Try this</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp; Date(Date#(Month_Field, 'M') ,'MM')</P><P>Regards</P><P>Vamsee</P></BODY></HTML> Fri, 04 May 2018 19:05:45 GMT https://community.qlik.com/t5/QlikView/Month-format/m-p/53568#M774489 vamsee 2018-05-04T19:05:45Z