topic Convert 13 digit date to proper date format (DD/MM/YYYY) in ArcGIS Pro Questions

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

JasonBenedict — Sat, 28 Aug 2021 19:12:56 GMT

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

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

DavidPike — Sat, 28 Aug 2021 19:47:42 GMT

If that's a Unix millisecond timestamp I think you can just field calculate with Arcade using

Date($feature.dateFieldname)

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

KenBuja — Mon, 30 Aug 2021 14:13:39 GMT

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

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