topic QvdCreateTime in App Development https://community.qlik.com/t5/App-Development/QvdCreateTime/m-p/1144637#M20410 <HTML><HEAD></HEAD><BODY><P>the following code num(QvdCreateTime('$(vPath)'));</P><P></P><P>gives me <SPAN style="color: #595959; font-family: 'Courier New'; font-size: 15.1278px;">42515.580104167 as a timestamp back</SPAN></P><P><SPAN style="color: #595959; font-family: 'Courier New'; font-size: 15.1278px;">while I was expecting something near:</SPAN></P><P></P><P>1464177919</P><P></P><P>how comes? and how to solve this ?</P></BODY></HTML> Wed, 25 May 2016 12:06:11 GMT jsnova 2016-05-25T12:06:11Z QvdCreateTime https://community.qlik.com/t5/App-Development/QvdCreateTime/m-p/1144637#M20410 <HTML><HEAD></HEAD><BODY><P>the following code num(QvdCreateTime('$(vPath)'));</P><P></P><P>gives me <SPAN style="color: #595959; font-family: 'Courier New'; font-size: 15.1278px;">42515.580104167 as a timestamp back</SPAN></P><P><SPAN style="color: #595959; font-family: 'Courier New'; font-size: 15.1278px;">while I was expecting something near:</SPAN></P><P></P><P>1464177919</P><P></P><P>how comes? and how to solve this ?</P></BODY></HTML> Wed, 25 May 2016 12:06:11 GMT https://community.qlik.com/t5/App-Development/QvdCreateTime/m-p/1144637#M20410 jsnova 2016-05-25T12:06:11Z Re: QvdCreateTime https://community.qlik.com/t5/App-Development/QvdCreateTime/m-p/1144638#M20411 <HTML><HEAD></HEAD><BODY><P>What you expect is the number of seconds sinds 1-1-1970. What you get instead is the number of days since 30-12-1899. Now that you now what the values are you can figure out how to turn one format into another.</P><P>Like this I think: <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">(QvdCreateTime('$(vPath)')) - MakeDate(1970)) * 86400</SPAN></P></BODY></HTML> Wed, 25 May 2016 15:24:21 GMT https://community.qlik.com/t5/App-Development/QvdCreateTime/m-p/1144638#M20411 Gysbert_Wassenaar 2016-05-25T15:24:21Z