topic Re: date to return a number in QlikView https://community.qlik.com/t5/QlikView/date-to-return-a-number/m-p/93742#M757323 <HTML><HEAD></HEAD><BODY><P>Perhaps: Weekday(MyDateField)+1</P></BODY></HTML> Thu, 20 Sep 2018 16:18:55 GMT Gysbert_Wassenaar 2018-09-20T16:18:55Z date to return a number https://community.qlik.com/t5/QlikView/date-to-return-a-number/m-p/93741#M757322 <HTML><HEAD></HEAD><BODY><P>I have dates&nbsp; where i need to return the number of the day ie </P><P>17/09/18 to return 1</P><P>18/09/18 to return 2</P><P>19/09/18 to return 3</P><P>20/09/18 to return 4</P><P>21/09/18 to return 5</P><P>22/09/18 to return 6</P><P>23/09/18 to return 7</P><P>24/09/18 to return 1&nbsp; etc</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/date-to-return-a-number/m-p/93741#M757322 dmxmikey 2020-11-25T16:16:04Z Re: date to return a number https://community.qlik.com/t5/QlikView/date-to-return-a-number/m-p/93742#M757323 <HTML><HEAD></HEAD><BODY><P>Perhaps: Weekday(MyDateField)+1</P></BODY></HTML> Thu, 20 Sep 2018 16:18:55 GMT https://community.qlik.com/t5/QlikView/date-to-return-a-number/m-p/93742#M757323 Gysbert_Wassenaar 2018-09-20T16:18:55Z Re: date to return a number https://community.qlik.com/t5/QlikView/date-to-return-a-number/m-p/93743#M757324 <HTML><HEAD></HEAD><BODY><P>Try this?</P><P></P><P>DateMap:</P><P>MAPPING LOAD * INLINE [</P><P>WeekDayName, ID</P><P>Mon,1</P><P>Tue,2</P><P>Wed,3</P><P>Thu,4</P><P>Fri,5</P><P>Sat,6</P><P>Sun,7</P><P>];</P><P></P><P></P><P>MapDates:</P><P></P><P></P><P>LOAD *,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; ApplyMap('DateMap',Text(WeekDay(Date#(Date2, 'DD/MM/YY')))) AS Day</P><P>&nbsp;&nbsp;&nbsp;&nbsp; INLINE [</P><P>Date2</P><P>17/09/18 </P><P>18/09/18 </P><P>19/09/18 </P><P>20/09/18 </P><P>21/09/18 </P><P>22/09/18 </P><P>23/09/18 </P><P>24/09/18</P><P>25/09/18 </P><P>];</P></BODY></HTML> Thu, 20 Sep 2018 16:29:20 GMT https://community.qlik.com/t5/QlikView/date-to-return-a-number/m-p/93743#M757324 vishsaggi 2018-09-20T16:29:20Z