Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming Aug. 9: New Simplified Authoring for Qlik Sense SaaS – For Details, CLICK HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
limu
Partner - Contributor II
Partner - Contributor II

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
Kushal_Chawda

@limu  I think you need below

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

View solution in original post

2 Replies
Kushal_Chawda

@limu  I think you need below

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

limu
Partner - Contributor II
Partner - Contributor II
Author

Hello Kush,

 

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