I am pulling a timestamp that looks like this:
How can I convert that?
This is UNIX time, see the answer here: https://community.qlik.com/thread/179779
i was going to suggest timestamp function but those values dont look right.
how does your source system create that time stamp field?
It is UNIX time.
Something like this should work
=TimeStamp(MakeDate(1970) + (1541187787161/86400000))
Where 864000000 = 24*60*60*1000
Thank you Sunny it is working now. And also I read up on it to understand a little more lol.
Have a wonderful day!
Retrieving data ...