topic Re: Converting Timestamp to Number in QlikView https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Number/m-p/1328619#M620434 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=Num(Timestamp#( '4/12/2017 15:44:26','M/D/YYYY hh:mm:ss'))</P><P></P><P>but you need to check the format of your input value, is it a numeric or text format?</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P></BODY></HTML> Mon, 17 Apr 2017 17:43:18 GMT swuehl 2017-04-17T17:43:18Z Converting Timestamp to Number https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Number/m-p/1328618#M620433 <HTML><HEAD></HEAD><BODY><P style="text-align: left;">Looking to convert a date from this format&nbsp; 4/12/2017 15:44:26 to this format 42826.315277778. I've tried to use a couple different functions such as num(), but no luck thus far. Any guidance would be appreciated!</P></BODY></HTML> Mon, 17 Apr 2017 17:40:13 GMT https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Number/m-p/1328618#M620433 2017-04-17T17:40:13Z Re: Converting Timestamp to Number https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Number/m-p/1328619#M620434 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>=Num(Timestamp#( '4/12/2017 15:44:26','M/D/YYYY hh:mm:ss'))</P><P></P><P>but you need to check the format of your input value, is it a numeric or text format?</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/2954">Why don’t my dates work?</A></P></BODY></HTML> Mon, 17 Apr 2017 17:43:18 GMT https://community.qlik.com/t5/QlikView/Converting-Timestamp-to-Number/m-p/1328619#M620434 swuehl 2017-04-17T17:43:18Z