topic Re: Automating date calculation in the Field Calculator in ArcGIS Pro Questions

Automating date calculation in the Field Calculator

DarrenDe_Lange — Tue, 15 Jun 2021 13:46:41 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 calculation in the Field Calculator

DavidPike — Tue, 15 Jun 2021 15:51:22 GMT

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

edit - I can see this same post was answered in Python questions.

Re: Automating date calculation in the Field Calculator

DarrenDe_Lange — Wed, 16 Jun 2021 06:33:22 GMT

Thank you David - I asked in both communities as I didn't know which was more relevant 🙂

Re: Automating date calculation in the Field Calculator

DarrenDe_Lange — Wed, 16 Jun 2021 08:07:33 GMT

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.

Re: Automating date calculation in the Field Calculator

DavidPike — Wed, 16 Jun 2021 08:30:50 GMT

I'd post any continuations as new posts to prevent threads becoming a Q and A or bugfixing session.

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

Re: Automating date calculation in the Field Calculator

DarrenDe_Lange — Wed, 16 Jun 2021 08:32:58 GMT

Thank you, will do that in future!