Changing Time Format

[hammermill21]

Hello,

I am pulling a timestamp that looks like this:

1541187787161

1531283800843

1541187787161

1531283800843

1541187787161

How can I convert that?

Thank you!

[Ivan_Bozov]

This is UNIX time, see the answer here: https://community.qlik.com/thread/179779

[dplr-rn]

i was going to suggest timestamp function but those values dont look right.

how does your source system create that time stamp field?

[hammermill21]

Hi,

It is UNIX time.

[sunny_talwar · Accepted solution]

Something like this should work

=TimeStamp(MakeDate(1970) + (1541187787161/86400000))

Where 864000000 = 24*60*60*1000

[hammermill21]

Thank you Sunny it is working now. And also I read up on it to understand a little more lol.

Have a wonderful day!