arcgis-10.2arcgis-desktopdatefield-calculator
I have one field for a permit decision date, and then I have another field for 180 days from that permit date. The permit date field has data entered, but the 180 day field I would like to calculate by adding 180 days. It is a feature class in a file GDB, and both fields are in date format (mm/dd/yyyy).
Example: Permit Field date is 7/1/2009, I would like the 180 days field to be 12/28/2009.
I am using ArcGIS 10.2.2 for Desktop.
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 need to convert your date into datetime object for max() to work correctly. It appears field calculator doesn't see the value as a datetime object. You may need to adjust the date format to suit your region date settings. See Strptime Behavior in the Python docs.
Using the Python Parser, select Show Codeblock. In the Pre-logic script code:
from datetime import datetime
def dtmax(*args):
f = '%m/%d/%Y %I:%M:%S %p'
dlist= list()
for d in args:
if d:
dlist.append(datetime.strptime(d, f))
return max(dlist)
Expression:
dtmax(!DateField1!, !DateField2!, !DateField3!, !DateField4!)
Best Answer
Pretty sure this is what you are looking for:
Simplify Date and Time Calculations