topic month(Date) in QlikView https://community.qlik.com/t5/QlikView/month-Date/m-p/510820#M190832 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to extract month info from a date (01/01/2014). Instead of getting Jan as the month output I would like to see 01 as the output.</P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 14 Jan 2014 17:22:46 GMT hkg_qlik 2014-01-14T17:22:46Z month(Date) https://community.qlik.com/t5/QlikView/month-Date/m-p/510820#M190832 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I would like to extract month info from a date (01/01/2014). Instead of getting Jan as the month output I would like to see 01 as the output.</P><P></P><P>Regards,</P><P>H</P></BODY></HTML> Tue, 14 Jan 2014 17:22:46 GMT https://community.qlik.com/t5/QlikView/month-Date/m-p/510820#M190832 hkg_qlik 2014-01-14T17:22:46Z Re: month(Date) https://community.qlik.com/t5/QlikView/month-Date/m-p/510821#M190833 <HTML><HEAD></HEAD><BODY><P>Use this...</P><P></P><P>=num(Month('01/01/2014'),'00')</P></BODY></HTML> Tue, 14 Jan 2014 17:26:35 GMT https://community.qlik.com/t5/QlikView/month-Date/m-p/510821#M190833 phaneendra_kunc 2014-01-14T17:26:35Z