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; } } }

ArcGIS Pro Date format defaults to mm/dd/yyyy

GeomaticsPublisher

Hi, I have a custom geoprocessing toolbox with a date field. The date picker showes the format as DD/MM/YYYY (12/05/2018) however the format being stored in the field (and being saved into the table) is MM/DD/YYYY (5/2/2018).

As there anyway of changing this so UK standard format dd/mm/yyyy is used in the field?

Thanks

Philip

date_format_issue.JPG

Find more posts tagged with

Accepted answers

All comments

SekouToure

Hi all,

We are in 2025, still no way to add a custom date format in ArcGIS PRO nor in AGOL.

God Bless you.

SteveHallSES

This is still an issue. Dates in my table are in DD/MM/YYYY but the date picker in Select by Attributes offers them only as MM/DD/YYYY and so the query fails.

kmsmikrud

I am also wondering about the data formatting in ArcGIS Pro and AGOL. I have a python script that uses the following datetime.strftime('%m/%d/%Y') and the output in the script/notebook shows 04/05/2021. When I view the format in AGOL and ArcGIS Pro I get 4/5/2021.

The desired format is what python is trying 04/05/2021, but not sure how to get this in the GIS feature classes/AGOL?

Appreciate any ideas?

Thanks,

Kathy

FredericPoliart_EsriAU

Same issue here.
The date-time picker stores the date in a format mm/dd/yyyy
(which causes other integrating issues with 3rd party applications)

I did change the global Windows settings | Date&Time Setting | Formats | Change Formats.. |

I could not find a date format setting inside ArcGIS Pro itself.

DanPatterson_Retired

Strange that it would switch the table's field when it save. I can't even find anything in arcmaps advanced settings in the

C:\Program Files (x86)\ArcGIS\Desktop10.6\Utilities folder. If the file destination is to a shapefile vs a geodatabase you might want to explore differences there.

I usually only have success when storing dates in a text field with the dates as strings.

GeomaticsPublisher

Thanks, I understand I can convert formats using convert time field or use python datetime modules. My question was around why the date picker in my images uses standing British format (from my windows system properties) but it then automatically changes this back to US format for the storage. Is there a way to change the default way ArcGIS stores date/time in a date field not to be mm/dd/yyyy depending on your region?

DanPatterson_Retired

From here http://pro.arcgis.com/en/pro-app/help/mapping/time/supported-field-formats.htm

You can do conversions using Convert Time Field

There are many other links for such topics as labelling etc using a "date format" search in the help

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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