Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
limu
Partner
Partner

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

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!

1 Solution

Accepted Solutions
Kush
MVP
MVP

@limu  I think you need below

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

View solution in original post

2 Replies
Kush
MVP
MVP

@limu  I think you need below

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

View solution in original post

limu
Partner
Partner
Author

Hello Kush,

 

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