arcgis-10.3arcgis-desktopdatefield-calculatorpython-parser
I am trying to change the format of date field using ArcMap field calculator.
My data is currently in the format "%d/%m/%Y %h:%m:%s" (e.g. 5/05/2016 12:25:46 AM)
I want to change this to "%d/%m/%Y" (e.g. 5/05/2016). No time data.
I have been trying to use the following, but this does not work.
datetime.strptime( !DateField!, "%d/%m/%Y)
I have looked at several similar questions posted, but none seem to do this?
Python or VBScript is ok, using ArcGIS 10.3
Use the DateAdd (or here) function. It looks like hours, minutes and seconds have to be added separately (3 calcs). I recommend adding a new date field and field calculating there... to preserve the original.
You can't remove the Hours/Minutes/Seconds while using the Date field type. You will have to convert to an alternative field type.
From ESRI on Working with Date Fields:
Enter dates in MM/DD/YYYY hh:mm:ss format
Regardless of how dates are displayed in the table, you can only enter dates in MM/DD/YYYY hh:mm:ss format, enclosed in single quotation marks. For example, to set a date field to 5:00PM on May 27, 2014, you would type '05/27/2014 05:00:00PM', '05/27/2014 5:00PM', or '05/27/2014 17:00:00' (24-hour clock). Storing time alone is not supported—time must always be a component of a date.
To correct I would suggest creating a string(text) field type as it will allow the format you are seeking of MM/DD/YYYY.
Best Answer
The dates are stored as strings (to be precise, unicode) meaning that you need to construct a true Python
datetimeobject and then manipulate it.If my date field
MyDateis2017-08-09 08:51:32, then I'd use this snippetstr(datetime.datetime.strptime(!MyDate!, "%Y-%m-%d %H:%M:%S").date())to get2017-08-09.If your date is
5/05/2016 12:25:46 AM, you would need to usestr(datetime.datetime.strptime(s, "%d/%m/%Y %H:%M:%S %p").date())to get5/05/2016