I need to convert the date field in the feature class. The original date format is 15-Jan-2012, 27-Apr-2012, likewise.
How can I convert it into MM/dd/yyyy format?
-
1You already accepted a Python answer.... but there is a tool that does this: desktop.arcgis.com/en/arcmap/latest/tools/…– KHibmaAug 13, 2021 at 19:03
Add a comment
|
1 Answer
Use Field Calculator with Python parser. I calculate a new field but you can overwrite your original field if you want to.
def convdate(f):
from datetime import datetime
dobj = datetime.strptime(f, '%d-%b-%Y') #Create a datetime object
newdate = datetime.strftime(dobj, '%m/%d/%Y') #Convert back to string in the format you ask for
return newdate
convdate( !datefield!) #Replace datefield with the name of your existing field
See: https://docs.python.org/2/library/datetime.html#strftime-and-strptime-behavior
to understand the '%d-%b-%Y' etc.