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

Jean-YvesLandry1 — Fri, 01 Jun 2018 01:43:59 GMT

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‌

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

JAcevedo_SacCity — Mon, 09 Sep 2024 23:33:41 GMT

Thank you this worked for me. However, I was able to apply the simple Excel conversion to my PowerBi Table (the table had already been converted from the Feature Service).

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

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

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