How do you convert epoch dates in Excel, Power Bi (query), Access from geodatabase

[Jean-YvesLandry1]

I constantly get this question so I decided to put a post on converting these 12 digit unix epoch dates (timestamp is in milliseconds) that you get when exporting your geodatabase.

Excel:

=(A1/86400/1000)+25569

*Don't forget to set the type to Date on your output cell.

Power Bi:

let
Source = #table({"Epoch"},{{1486933998060}}),
#"Added Custom" = Table.AddColumn(Source, "Custom", each #datetime(1970,1,1,0,0,0)+#duration(0,0,0,[Epoch]/1000))
in
#"Added Custom"

e.g.

Access:

Format    dd/mm/yyyy hh:nn:ss

e.g. 

epoch datetime calculation‌

gdb to excel‌

access‌

power bi‌

unix‌

#date‌