topic Re: How to create DAY in QlikView https://community.qlik.com/t5/QlikView/How-to-create-DAY/m-p/1380901#M798844 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>date(Day,'DD')</P><P>But please verify if it is giving correct days output?</P><P>I'm not sure if that is correct</P></BODY></HTML> Mon, 11 Dec 2017 16:24:36 GMT MK9885 2017-12-11T16:24:36Z How to create DAY https://community.qlik.com/t5/QlikView/How-to-create-DAY/m-p/1380900#M798843 <HTML><HEAD></HEAD><BODY><P>Hi im having DAY in date&nbsp; D format ie 1,2,3,..., But i want in 'DD' ie&nbsp; 01,02,03 format,</P><P>Im applying logic <STRONG style="color: #ff6600;">num(DAY,'00')</STRONG> Format&nbsp; but its not giving any output , can anyone help me out </P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/How-to-create-DAY/m-p/1380900#M798843 munnawar 2020-11-25T16:16:04Z Re: How to create DAY https://community.qlik.com/t5/QlikView/How-to-create-DAY/m-p/1380901#M798844 <HTML><HEAD></HEAD><BODY><P>Maybe</P><P></P><P>date(Day,'DD')</P><P>But please verify if it is giving correct days output?</P><P>I'm not sure if that is correct</P></BODY></HTML> Mon, 11 Dec 2017 16:24:36 GMT https://community.qlik.com/t5/QlikView/How-to-create-DAY/m-p/1380901#M798844 MK9885 2017-12-11T16:24:36Z Re: How to create DAY https://community.qlik.com/t5/QlikView/How-to-create-DAY/m-p/1380902#M798845 <HTML><HEAD></HEAD><BODY><P>Try one of <SPAN style="font-size: 10pt;">this</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Date(DAY,'DD')</STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Or</STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></STRONG></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;"><STRONG style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Date(Date#(DAY,'DD'))</STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></STRONG></SPAN></P><P><SPAN style="font-size: 10pt;"><STRONG style="color: #000000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;"><BR /></STRONG></SPAN></P></BODY></HTML> Mon, 11 Dec 2017 17:51:03 GMT https://community.qlik.com/t5/QlikView/How-to-create-DAY/m-p/1380902#M798845 its_anandrjs 2017-12-11T17:51:03Z