nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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.

Encontre mais publicações marcadas com

Accepted answers

All comments

ErnestoCarreras3

Thanks to both of you!!!

MattSayler

Great minds. 🙂

ChrisSnyder

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

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)

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

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.