topic Re: Date Transformation in QlikView https://community.qlik.com/t5/QlikView/Date-Transformation/m-p/1346914#M846181 <HTML><HEAD></HEAD><BODY><P><STRONG>num(date#('4/5/2017','MM/DD/YYYY'))</STRONG></P></BODY></HTML> Wed, 05 Apr 2017 13:24:40 GMT surendraj 2017-04-05T13:24:40Z Date Transformation https://community.qlik.com/t5/QlikView/Date-Transformation/m-p/1346913#M846180 <HTML><HEAD></HEAD><BODY><P>Hey all ,</P><P></P><P>How can I convert this Date "4/5/2017" into a number ?</P><P>Noting that it is a Month/Day/Year in this the number show be "42830"</P><P></P><P>Thank you</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date-Transformation/m-p/1346913#M846180 mario-sarkis 2020-11-25T16:16:04Z Re: Date Transformation https://community.qlik.com/t5/QlikView/Date-Transformation/m-p/1346914#M846181 <HTML><HEAD></HEAD><BODY><P><STRONG>num(date#('4/5/2017','MM/DD/YYYY'))</STRONG></P></BODY></HTML> Wed, 05 Apr 2017 13:24:40 GMT https://community.qlik.com/t5/QlikView/Date-Transformation/m-p/1346914#M846181 surendraj 2017-04-05T13:24:40Z Re: Date Transformation https://community.qlik.com/t5/QlikView/Date-Transformation/m-p/1346915#M846182 <HTML><HEAD></HEAD><BODY><P>Try using the number function. For example num('4/5/2017','####0') and this should give you the number 42859.</P></BODY></HTML> Wed, 05 Apr 2017 13:26:07 GMT https://community.qlik.com/t5/QlikView/Date-Transformation/m-p/1346915#M846182 Anonymous 2017-04-05T13:26:07Z