topic Re: Automating date calculations in field calculator in Python Questions

Automating date calculations in field calculator

DarrenDe_Lange — Tue, 15 Jun 2021 13:49:45 GMT

Good afternoon all!

I am trying to automate date calculations using the field calculator in ArcGIS Pro.

I have defined survey dates, which I would like to use to create a reinspection dates.

The reinspection date is 1 year for high risk zones, 3 years for medium risk zone and 5 years for low risk zones.

Is there a piece of code I could use in the field calculator to automate this calculation?

The best sample I came out with for high risk zones is:

Expression:
arcpy.time.ParseDateTimeString(!SurveyDate!) + datetime.timedelta(days=365)

However, this did not work when I tried to execute the script.

Any help is appreciated.

Thank you

Re: Automating date calculations in field calculator

JoshuaBixby — Tue, 15 Jun 2021 14:09:00 GMT

Regarding

However, this did not work when I tried to execute the script.

It always helps to be more specific. What exactly does "did not work" mean? Did you get an error? If so, what error, specifically? Did you get an unexpected result? if so, what were you expecting and what did you get?

You should be able to simply retrieve the date and add the time to it:

!SurveyDate! + datetime.timedelta(days=365)

Re: Automating date calculations in field calculator

DarrenDe_Lange — Tue, 15 Jun 2021 14:30:52 GMT

Thank you for your help, that has worked. I just need to create an 'if' statement now.

Is one able to loop the statement in the field calculator whenever a new entry is created?

Re: Automating date calculations in field calculator

BlakeTerhune — Tue, 15 Jun 2021 14:32:56 GMT

You say it did not work but what was the result? No values? Incorrect values? Error message? In the case of an error, what was the complete message (check the geoprocessing results)?

If you're working with the datetime library, you'll need to import datetime

Try something like this for the Python code block

def calc_reinspection(survey_date): date_str_format = "%d/%m/%Y" survey_date = datetime.datetime.strptime(survey_date, date_str_format) reinspection_date = survey_date + datetime.timedelta(days=365) return datetime.datetime.strftime(reinspection_date, date_str_format)

That last line is formatting the datetime object back to a string formatted date to exclude the time portion (which defaults to midnight). You can leave that part out if you don't mind your dates all having the time displayed (even though they do have it hidden); just return reinspection_date.

And this for the Python expression:

calc_reinspection(!SurveyDate!)

Re: Automating date calculations in field calculator

BlakeTerhune — Tue, 15 Jun 2021 18:07:57 GMT

Not sure what you mean by looping the statement in the field calculator. Calculate field will perform the operation on all (or selected) records once. If you want it to do multiple things when you run calculate field, you'll have to code that logic; possibly using an if statement.

If you want to automatically do something when a condition is met (new record, new value, etc), that would be something different. Maybe look into Attribute Assistant or Attribute Rules. If it's in an RDBMS, you could make a database trigger. Or if it doesn't need to be immediate, you could schedule a Python script as a Windows task.

Re: Automating date calculations in field calculator

DarrenDe_Lange — Wed, 16 Jun 2021 08:09:22 GMT

Hi Blake - Thank you for your response.

I am now trying to add in the risk zones and my statement does not seem to be working.

Field Calculator:

Expression line: reclass(!SurveyDate!) Code block: def reclass(SurveyDate): if (RiskZone = LOW): return "SurveyDate + datetime.timedelta(days=486)" elif (RiskZone = MED): return return "SurveyDate + datetime.timedelta(days=1095)" elif (RiskZone = HIGH): return return "SurveyDate + datetime.timedelta(days=1825)"

Attached is the syntax error.

Any assistance is appreciated.

Thank you

Re: Automating date calculations in field calculator

BlakeTerhune — Wed, 16 Jun 2021 16:18:57 GMT

That error is because you are using a single = which is for assignment. Use double == for comparing equality. And you probably want quotes around the LOW value to indicate it's a string and not a variable that isn't defined.

if (RiskZone == "LOW"):

Also, get rid of the double return keywords; just one will do 😉

Re: Automating date calculations in field calculator

DarrenDe_Lange — Thu, 17 Jun 2021 07:37:02 GMT

Thank you 😊