topic Re: Changing date column from US to UK format in ArcGIS Online Questions

Changing date column from US to UK format

DarrenDe_Lange — Mon, 01 Mar 2021 15:14:18 GMT

Hi there

I am needing to change date columns from US format (mm-dd-yyyy) to UK format (dd-mm-yyyy).

Can this be done on ArcGIS online or ArcGIS Pro?

Using the field calculator?

Thank you for any assistance.

Re: Changing date column from US to UK format

GWGazza — Mon, 01 Mar 2021 15:45:34 GMT

https://pro.arcgis.com/en/pro-app/latest/help/data/tables/date-fields.htm

Dates are stored yyyy/mm/dd and displayed according to your windows system settings.

Re: Changing date column from US to UK format

jcarlson — Mon, 01 Mar 2021 15:50:18 GMT

A date field is actually stored as a timestamp, which is just an integer understood to be "seconds since some date".

In order to change how your date field displays in AGOL, go into the Configure Popups → Configure Attributes dialog in a webmap:

According to the Pro docs, the date field display is determined by your machine settings. I do wish that there were more formatting options for datetime fields in Pro.

Re: Changing date column from US to UK format

DarrenDe_Lange — Thu, 15 Apr 2021 08:50:12 GMT

Thank you Josh, your help is much appreciated.

Re: Changing date column from US to UK format

ArmandFrançois — Fri, 10 Feb 2023 09:20:05 GMT

Hi Dear,

We do configure sometimes a lot of layers with date in a single webmap, and we would like to set up a defaut format. So we dont need to configure it all one by one. Do you know any way to do that ?

Best Regards,

Armand FRANCOIS