Forum Discussion
REST API date format unfixable
That looks like epoch time (seconds since 1/1/1970), if you take away a few of the trailing 0s.
Epoch Converter - Unix Timestamp Converter
Pat
That looks like epoch time (seconds since 1/1/1970), if you take away a few of the trailing 0s.
Epoch Converter - Unix Timestamp Converter
Pat
Thank you! That pointed me in the right direction and lead me to this video from Curbal https://www.youtube.com/watch?v=IEHq-rUcf-g which helped me create the below code (had to convert the #duration calculation from milliseconds which is what the original epoch time column is in, so that is why there is a divide by 1000 added).
Below presumes the original column has been converted to Text format (hence my step of "Changed epoch dates to text" prior to this TransformColumns step):
= Table.TransformColumns(#"Changed epoch dates to text", {{"features.properties.reportedDate", each #datetime(1970,1,1,0,0,0) +#duration(0,-6,0,Number.From(_)/1000), type datetime}})