topic Convert today into Month number in QlikView https://community.qlik.com/t5/QlikView/Convert-today-into-Month-number/m-p/167017#M38747 <HTML><HEAD></HEAD><BODY><P>This is hopefully a very simple question:</P><P>I'm looking for a function to get the <B>number</B> of the month of the current date.</P><P>When I use <B>month(today())</B> I get back 'Mar.' I'd like to instead get back '03.'</P><P></P><P>Thanks</P></BODY></HTML> Wed, 03 Mar 2010 17:51:37 GMT 2010-03-03T17:51:37Z Convert today into Month number https://community.qlik.com/t5/QlikView/Convert-today-into-Month-number/m-p/167017#M38747 <HTML><HEAD></HEAD><BODY><P>This is hopefully a very simple question:</P><P>I'm looking for a function to get the <B>number</B> of the month of the current date.</P><P>When I use <B>month(today())</B> I get back 'Mar.' I'd like to instead get back '03.'</P><P></P><P>Thanks</P></BODY></HTML> Wed, 03 Mar 2010 17:51:37 GMT https://community.qlik.com/t5/QlikView/Convert-today-into-Month-number/m-p/167017#M38747 2010-03-03T17:51:37Z Convert today into Month number https://community.qlik.com/t5/QlikView/Convert-today-into-Month-number/m-p/167018#M38748 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>Use instead</P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">=Num(Month(Today()), '00')</PRE></BLOCKQUOTE><BR /><BR /></BODY></HTML> Wed, 03 Mar 2010 18:20:00 GMT https://community.qlik.com/t5/QlikView/Convert-today-into-Month-number/m-p/167018#M38748 Miguel_Angel_Baeyens 2010-03-03T18:20:00Z