Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

jsnova0101
New Contributor II

QvdCreateTime

the following code num(QvdCreateTime('$(vPath)'));

gives me 42515.580104167 as a timestamp back

while I was expecting something near:

1464177919

how comes? and how to solve this ?

1 Solution

Accepted Solutions

Re: QvdCreateTime

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.

Like this I think: (QvdCreateTime('$(vPath)')) - MakeDate(1970)) * 86400


talk is cheap, supply exceeds demand
1 Reply

Re: QvdCreateTime

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.

Like this I think: (QvdCreateTime('$(vPath)')) - MakeDate(1970)) * 86400


talk is cheap, supply exceeds demand