Discussion Board for collaboration related to QlikView App Development.
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:
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!
@limu I think you need below
=Timestamp(25569 + Round(num(Replace(event_timestamp, ',', '.'), '(dec)')/1000000) / 86400)
View solution in original post
thank you for your reply! I had to remove the Replace() part and it worked!