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

What is the required format for dates in Field calculator in ArcGIS 10.3.1

SimonCrutchley

This may seem like a simple question, but I'm having problems. According to the "Fundamentals of date fields" in ArcGIS 10.3.1, " a shapefile stores dates in a date field with this format: yyyy-mm-dd". However, when I put 2017-03-07 into my field, formatted as a date field, in Field Calculator, what comes out is 29/06/1905! If I just enter that into the individual field, it works fine, just not in the field calculator, and unfortunately I need to populate a number of shapefiles, each with several hundred rows.

What am I doing wrong?

Find more posts tagged with

Accepted answers

DanPatterson_Retired

did you try

datetime.datetime(2000, 12, 31)

All comments

DanPatterson_Retired

did you try

datetime.datetime(2000, 12, 31)

SimonCrutchley

No, but I have now, and it works

Thank you.

SimonCrutchley

Hi Dan,

This works, but it comes out in US format (mm/dd/yyyy). Is there a way so that it works in UK (dd/mm/yyyy). I know that I can alter the display in pop-ups and the attribute table, but when I set up a query in Portal, it is asking for input in US, which could confuse my potential users.

Thanks

DanPatterson_Retired

Simon... I don't do the portal thing, and the inputs to datetime can be constructed from the individual year, month, day components, but you can't switch their order in datetime.datetime. Display for your locale can be controlled by windows.

I only work with standardized YYYY-MM-DD format so I have little experience with localized preferences

GISP MAP Image.png

SimonCrutchley

Hi Dan,

Thanks anyway. At least you got my data to appear in the right century! I'll try other tacks.

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.