Nilesh Suraskar on 17 Feb 2023 11:18:45
For 10 digit Epoch/Unix time Power Query custom column gives the correct datetime for "1676629332"= 02/17/2023 10:22:12 AM
by using the function as
date = #datetime(1970,1,1,0,0,0) + #duration(0,0,0,[timestamp])
but I have imported the data from New Relic Web API which consist of timestamp as "13 digit" as (1676629251256) when I used the same function as
date = #datetime(1970,1,1,0,0,0) + #duration(0,0,0,[timestamp])
it gives the error
I am not able to convert this into datetime by Power Query, Kindly help to solve this query