topic Conveting a date in QlikView https://community.qlik.com/t5/QlikView/Conveting-a-date/m-p/213273#M67045 <HTML><HEAD></HEAD><BODY><P>HI.</P><P>Try the following:</P><P></P><P>date(monthstart(today()),'YYYY/MM')</P><P>Regards.</P><BR /><BR /></BODY></HTML> Fri, 11 Feb 2011 19:43:34 GMT spividori 2011-02-11T19:43:34Z Conveting a date https://community.qlik.com/t5/QlikView/Conveting-a-date/m-p/213271#M67043 <HTML><HEAD></HEAD><BODY><P>Hi, I need that the result of the code above be like this: '2001/02', but it's bringing me '2001/2'</P><P></P><PRE ___default_attr="plain" class="jive_text_macro jive_macro_code" jivemacro="code"><BR />year(today())&amp;'/'&amp;num(month(today()))<BR /></PRE><BR /><BR /> <P></P><P>How can I fix that please?</P></BODY></HTML> Fri, 11 Feb 2011 19:34:58 GMT https://community.qlik.com/t5/QlikView/Conveting-a-date/m-p/213271#M67043 rcandeo 2011-02-11T19:34:58Z Conveting a date https://community.qlik.com/t5/QlikView/Conveting-a-date/m-p/213272#M67044 <HTML><HEAD></HEAD><BODY><P>Hello Robson,</P><P>That's because of the Num() function, as in numbers, a leading zero doesn't make the difference. Try instead</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;">Date(Today(), 'YYYYMM')</PRE></BLOCKQUOTE><BR /><BR /> <P>Hope that helps.</P></BODY></HTML> Fri, 11 Feb 2011 19:42:08 GMT https://community.qlik.com/t5/QlikView/Conveting-a-date/m-p/213272#M67044 Miguel_Angel_Baeyens 2011-02-11T19:42:08Z Conveting a date https://community.qlik.com/t5/QlikView/Conveting-a-date/m-p/213273#M67045 <HTML><HEAD></HEAD><BODY><P>HI.</P><P>Try the following:</P><P></P><P>date(monthstart(today()),'YYYY/MM')</P><P>Regards.</P><BR /><BR /></BODY></HTML> Fri, 11 Feb 2011 19:43:34 GMT https://community.qlik.com/t5/QlikView/Conveting-a-date/m-p/213273#M67045 spividori 2011-02-11T19:43:34Z