nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Changing date column from US to UK format

DarrenDe_Lange

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.

Vind meer berichten getagd met

Sharing and collaboration

Data and services

Mapping

Accepted answers

jcarlson

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.

All comments

GWGazza

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.

jcarlson

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.

DarrenDe_Lange

Thank you Josh, your help is much appreciated.

ArmandFrançois

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

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.