topic Re: Timestamp in another format, can't convert it to a valid date in QlikView

Timestamp in another format, can't convert it to a valid date

limu — Sat, 16 Nov 2024 18:02:03 GMT

Hello,

I'm trying to convert some timestamps into date, but can't convert them correctly. The format of the timestamps seems to be different. Example of a timestamp:

1,600657930901e+15

When I try to convert it with the following code: Date(event_timestamp, 'MM/DD/YYYY hh:mm:ss')

I get: 02/28/1478297557 00:00:00

Can someone help me transfrom it to a date with the format DD-MM-YYYY hh:mm:ss?

Thank you in advance!

Re: Timestamp in another format, can't convert it to a valid date

Kushal_Chawda — Wed, 30 Sep 2020 15:03:09 GMT

@limu I think you need below

=Timestamp(25569 + Round(num(Replace(event_timestamp, ',', '.'), '(dec)')/1000000) / 86400)

Re: Timestamp in another format, can't convert it to a valid date

limu — Thu, 01 Oct 2020 07:58:15 GMT

Hello Kush,

thank you for your reply! I had to remove the Replace() part and it worked!