topic Field Calculator - DateDiff() function Python Equivalent in Python Questions

Field Calculator - DateDiff() function Python Equivalent

NickMoylan — Fri, 03 Oct 2014 18:25:58 GMT

Hello, I have a model that calculates an integer field with the DateDiff() function. The difference is between an 'expiry_date'(date type) field formatted "mm/dd/yyyy" and the now() function. I want to export this model to a Python script, however it wont allow the VB function to be used. It is a large model that I would rather not rewrite, is there python code that I can use in the tool before I export it to a python script in place of the VB to calculate this integer field??

Re: Field Calculator - DateDiff() function Python Equivalent

JasonScheirer — Sun, 05 Oct 2014 22:07:21 GMT

You can use the datetime module.

Code block:

import datetime

Expression:

(datetime.datetime.now() - datetime.datetime.strptime(!field_with_formatted_date!, "%m/%d/%Y")).days

Re: Field Calculator - DateDiff() function Python Equivalent

NickMoylan — Mon, 06 Oct 2014 18:23:06 GMT

This works great!

Thanks foir the help.