topic Re: Date Format in QlikView https://community.qlik.com/t5/QlikView/Date-Format/m-p/112533#M603657 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">num(month(today()),'00')</SPAN></P></BODY></HTML> Mon, 10 Sep 2018 14:46:36 GMT Frank_Hartmann 2018-09-10T14:46:36Z Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/112532#M603656 <HTML><HEAD></HEAD><BODY><P>Hello Qlik folks,</P><P></P><P>My date format is set as MM/DD/YYYY &amp; =today() is giving me 09/10/2018</P><P></P><P>why =num(month(today())) giving me just 9, what I need is 09</P><P></P><P></P><P></P><P></P><P>Thanks,</P><P>D</P></BODY></HTML> Mon, 10 Sep 2018 14:44:52 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/112532#M603656 dseelam 2018-09-10T14:44:52Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/112533#M603657 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">num(month(today()),'00')</SPAN></P></BODY></HTML> Mon, 10 Sep 2018 14:46:36 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/112533#M603657 Frank_Hartmann 2018-09-10T14:46:36Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/112534#M603658 <HTML><HEAD></HEAD><BODY><P>num don't gives you preceding Zeros, just 9 as integer</P><P>using date(today(),'MM') gives you 09</P></BODY></HTML> Mon, 10 Sep 2018 14:47:30 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/112534#M603658 Anonymous 2018-09-10T14:47:30Z Re: Date Format https://community.qlik.com/t5/QlikView/Date-Format/m-p/112535#M603659 <HTML><HEAD></HEAD><BODY><P>Thank you </P></BODY></HTML> Mon, 10 Sep 2018 14:51:31 GMT https://community.qlik.com/t5/QlikView/Date-Format/m-p/112535#M603659 dseelam 2018-09-10T14:51:31Z