topic Re: Assinging Number to a Date in QlikView https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398486#M806038 <HTML><HEAD></HEAD><BODY><P>Try like this </P><P></P><P>DayNumberOfYear (<SPAN style="color: #ff0000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">EXP_REP_STATUS_DATE</SPAN>,7)&nbsp; as Daynumber </P></BODY></HTML> Thu, 02 Nov 2017 08:00:13 GMT prma7799 2017-11-02T08:00:13Z Assinging Number to a Date https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398485#M806037 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I want to assign a number to date where 1st Jul is start date. So&nbsp; for eg, :</P><UL><LI><SPAN style="font-size: 10pt;">1st July&nbsp; = 1</SPAN></LI><LI>2nd July = 2</LI><LI>3rd Jul =&nbsp; 3</LI><LI>...</LI><LI>...</LI><LI>30 Jun = 365</LI></UL><P></P><P>How do i do this.</P><P></P><P>I have the following script below, however, the 1st Jan = 1.</P><P><SPAN style="color: #ff0000;">num(EXP_REP_STATUS_DATE+1)-num(makedate(year(EXP_REP_STATUS_DATE),1,1)) as DayNumber,</SPAN></P><P><SPAN style="color: #808080;"><BR /></SPAN></P><P><SPAN style="color: #808080;">Kind regards,</SPAN></P><P><SPAN style="color: #ff0000;"><SPAN style="color: #808080;">Nayan</SPAN><BR /></SPAN></P><P><SPAN style="color: #ff0000;"><BR /></SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398485#M806037 Anonymous 2020-11-25T16:16:04Z Re: Assinging Number to a Date https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398486#M806038 <HTML><HEAD></HEAD><BODY><P>Try like this </P><P></P><P>DayNumberOfYear (<SPAN style="color: #ff0000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">EXP_REP_STATUS_DATE</SPAN>,7)&nbsp; as Daynumber </P></BODY></HTML> Thu, 02 Nov 2017 08:00:13 GMT https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398486#M806038 prma7799 2017-11-02T08:00:13Z Re: Assinging Number to a Date https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398487#M806039 <HTML><HEAD></HEAD><BODY><P>Thanks PM , It worked <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 02 Nov 2017 08:08:19 GMT https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398487#M806039 Anonymous 2017-11-02T08:08:19Z Re: Assinging Number to a Date https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398488#M806040 <HTML><HEAD></HEAD><BODY><P>Welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Thu, 02 Nov 2017 08:09:26 GMT https://community.qlik.com/t5/QlikView/Assinging-Number-to-a-Date/m-p/1398488#M806040 prma7799 2017-11-02T08:09:26Z