Calculate date difference

[ErnestoCarreras3]

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.

[MattSayler]

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

[ChrisSnyder]

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)

[ChrisSnyder]

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

[MattSayler]

Great minds. 🙂

[ErnestoCarreras3]

Thanks to both of you!!!