ArcPy – How to Calculate Day Difference Between Two Fields in ArcGIS Pro

arcgis-proarcpydate

I work with ArcGIS Pro 3.1. I have a GDB table with two date fields. I would like calculate with Python code the difference between two date in days. But the result is not correct if the months are different (For example: ID 3 and 4).

arcpy.management.AddField(tabl, "day","TEXT")
exc= "computeDiff(!e_date!, !s_date!)"
codeblock="""
def computeDiff(start,end):
  FMT = "%Y. %M. %d."
  tday = datetime.datetime.strptime(start, FMT) - datetime.datetime.strptime(end,FMT)
  return str(tday)"""
arcpy.management.CalculateField(tabl, "day", exc, "PYTHON_9.3",codeblock)

Best Answer

The format code for "month" is a lower-case %m. You're currently specifying "year minute day".

https://docs.python.org/3/library/datetime.html#strftime-and-strptime-format-codes

Related Solutions

ArcGIS Pro Field Calculator – Update Rows with Incremented Time

First of all as @Vince points out, shapefile format was a poor choice for creating your data in. If you type into the help file "Geoprocessing considerations for shapefile output" you will discover why. So what you want cannot be achieved in a Shapefile; create your data in a File GeoDatabase. I would also add abandon any future work with Shapefiles as the File GeoDatabase is a superior format offering lots of functionality that a Shapefile cannot. You will literally be working faster and smarter with a File Geodatabase!

With that said the Python code to use in a Calculate Field tool could be:

DT = None
def ComputeTime():
    global DT
    if DT is None:
        DT = datetime.datetime(2022,7,14,12,0,0,0)
    DT = DT + datetime.timedelta(minutes=1)
    return DT

The tool being set up as below:

Best Answer

Related Solutions

ArcGIS Pro Field Calculator – Update Rows with Incremented Time

Related Question