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

Date field

Tonyalmeida

I have a feature class with hundreds of features. The date field in a feature class was populated incorrectly;
1/2/2003.
i am looking for a python code that can add the zero's to the field to make them correct like; 01/02/2013.

Any help would be great.

Vind meer berichten getagd met

Accepted answers

ShaunWalbridge

Try something like this:

    input_field = "Date_Time"     expression = 'formatDate(!{input_field}!)'.format(input_field=input_field)     code_block = """ import dateutil.parser def formatDate(input_date):     parsed_date = dateutil.parser.parse(input_date)     return parsed_date.strftime("%m/%d/%Y")"""          arcpy.AddField_management(input_featureclass, "formatted_output_date", 'DATE')     arcpy.CalculateField_management(input_featureclass, field_name, expression, "PYTHON_9.3", code_block)

strftime's %m and %d will produce values with leading zeros where needed, and the dateutil parser will work for dates formatted in other ways as well.

cheers,
Shaun

All comments

ShaunWalbridge

If you change the output type to string, you'll see the leading zeros. But as msayler mentioned, if you store things as dates, they will be displayed based on locale and not in the specified format explicitly.

Tonyalmeida

msayler thanks for the info and your help.

MattSayler

Nope. I think it would have to be a setting somewhere that lets you adjust how dates are displayed. You can even try manually typing the date in as "01/01/1950" and it will show up as "1/1/1950" after it updates.

And again, it's really just aesthetics. If you want them in a different format for displaying on a map or in a report, you can probably still do that.

If you need to do math on the dates, you can also use python for that. Here's a thread where someone needed to get time deltas in days:
http://forums.arcgis.com/threads/97156-Calculate-date-difference

Tonyalmeida

oh ok i was expecting to pysically see the "0" in the date field.

Is there a ways to do this in Field calculator?

MattSayler

If the field is a 'date' data type, then it's probably stored correctly, and that's just how ArcGIS is programmed to interpret for display. Dates are a little different than other data types.

You can pull the dates out in the format you want using strftime like Shaun said. I'm not sure if you can change the default way they're displayed in ArcMap. I didn't find a setting doing a quick search of the usual spots anyway.

Here's a link on strftime and the various '%' codes that can be used for the format string:
http://docs.python.org/2.7/library/datetime.html?highlight=datetime#strftime-and-strptime-behavior

Tonyalmeida

Thank you swalbridge for the response, the code you provided only seemed to copy the field but did not add the leading zero's.
The field is a Date field data type, i don't know if that makes a difference or not.
Also can this be done in field calculator?

ShaunWalbridge

Try something like this:

    input_field = "Date_Time"     expression = 'formatDate(!{input_field}!)'.format(input_field=input_field)     code_block = """ import dateutil.parser def formatDate(input_date):     parsed_date = dateutil.parser.parse(input_date)     return parsed_date.strftime("%m/%d/%Y")"""          arcpy.AddField_management(input_featureclass, "formatted_output_date", 'DATE')     arcpy.CalculateField_management(input_featureclass, field_name, expression, "PYTHON_9.3", code_block)

strftime's %m and %d will produce values with leading zeros where needed, and the dateutil parser will work for dates formatted in other ways as well.

cheers,
Shaun

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.