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

[limu]

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!

[Kushal_Chawda · Accepted solution]

@limu  I think you need below

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

[limu]

Hello Kush,

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