Convert 13 digit date to proper date format (DD/MM/YYYY)

Question

Hello,

I have a numeric field that represents dates in an attribute table that contains 13 digits (e.g 1457222400000). I have seen a few posts like this on converting this to dates if it's in 5 digits but not a number with this many digits.

Is there an easy way I convert this to a proper date format using the field calculator or Arcpy?

Many thanks in advance!

Jason

kenbuja · Accepted Answer

You'll also want to use the Text function to properly format the date.

Text(Date($feature.dateFieldname), 'D/M/Y')