AnsweredAssumed Answered

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

Question asked by JeanYves.Landry_ERM on May 31, 2018

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

Outcomes