topic Re: Calculate date difference in Python Questions

Calculate date difference

ErnestoCarreras3 — Tue, 19 Nov 2013 18:51:09 GMT

Hi,
I need to calculate the difference between two dates in days. I need it to work within the Model Builder since these are models that need to be published later as a GP service. I have two fields, one with the Inspection date and the other with the Current date.
Something similar to the below VBscript:

DateDiff("d", [date_field], Now())

Any advice will be appreciated. Thanks in advanced.

Re: Calculate date difference

MattSayler — Sun, 12 Dec 2021 04:54:54 GMT

You can do that with the 'datetime' module:
http://docs.python.org/release/2.6.8/library/datetime.html

Something like:

import datetime
date1 = "1/1/1990"
date2 = "1/1/1980"
x = datetime.datetime.strptime(date1, "%m/%d/%Y")
y = datetime.datetime.strptime(date2, "%m/%d/%Y")
z = x - y
print z.days

Re: Calculate date difference

ChrisSnyder — Sun, 12 Dec 2021 04:54:56 GMT

Not sure how to pull it off in model builder, but the Python datetime module works like this:

import datetime, arcpy
time1 = arcpy.da.SearchCursor(myFC, ["MY_DATE_FIELD"], "OBJECTID = 1").next()
time2 = datetime.datetime.now()
elapsedTime = time2 - time1
print "Total elapsed seconds: " + str(elapsedTime.totalSeconds)
print "Total elapsed days: " + str(elapsedTime.days)

Re: Calculate date difference

ChrisSnyder — Tue, 19 Nov 2013 22:08:48 GMT

Woops - jinx - had that window open too long before I hit submit!

Re: Calculate date difference

MattSayler — Tue, 19 Nov 2013 22:31:25 GMT

Great minds. 🙂

Re: Calculate date difference

ErnestoCarreras3 — Wed, 20 Nov 2013 18:24:43 GMT

Thanks to both of you!!!