topic Re: How to add a date field and custom date? in Python Questions

How to add a date field and custom date?

nsidaniel — Wed, 28 Sep 2022 13:55:57 GMT

I'm trying to add a date field without it taking too long. Using arcpy.da.UpdateCursor took forever, so I'm trying Add field and calculate field ... which I cannot seem to get working! Any advice is appreciated! ArcGIS 2.9. Below is part of my code.

Thank you - Daniel

import arcpy, os, sys import datetime PatrolDateCalc = datetime.date(2022, 9, 19) fc = oh field = "PatrolDate" if arcpy.ListFields(fc, field) == True: Print ("PatrolDate" + fc + "field already present") else: arcpy.management.AddField(fc, field, "DATE", "10", "", "", "Patrol Date", "", "NON_REQUIRED") arcpy.management.CalculateField(fc, field, PatrolDateCalc, "PYTHON3", "", "DATE", "NO_ENFORCE_DOMAINS") fc = ug field = "PatrolDate" if arcpy.ListFields(fc, field) == True: Print ("PatrolDate" + fc + "field already present") else: arcpy.management.AddField(fc, field, "DATE", "10", "", "", "Patrol Date", "", "NON_REQUIRED") arcpy.management.CalculateField(fc, field, PatrolDateCalc, "PYTHON3", "", "DATE", "NO_ENFORCE_DOMAINS") In [14]: Line: arcpy.management.CalculateField(fc, field, PatrolDateCalc, "PYTHON3", "", "DATE", "NO_ENFORCE_DOMAINS") File C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py, in CalculateField: Line 5588: raise e File C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py, in CalculateField: Line 5585: retval = convertArcObjectToPythonObject(gp.CalculateField_management(*gp_fixargs((in_table, field, expression, expression_type, code_block, field_type, enforce_domains), True))) File C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py, in <lambda>: Line 512: return lambda *args: val(*gp_fixargs(args, True)) ExecuteError: Failed to execute. Parameters are not valid. ERROR 000840: The value is not a SQL Expression. Failed to execute (CalculateField).

Re: How to add a date field and custom date?

dgiersz_cuyahoga — Tue, 27 Sep 2022 16:45:38 GMT

Where is "PatrolDateCalc" declared? I don't see it.

Re: How to add a date field and custom date?

DonMorrison1 — Tue, 27 Sep 2022 16:46:39 GMT

I assume it is complaining about 'PatrolDateCalc', which I done see being defined anywhere.

Re: How to add a date field and custom date?

nsidaniel — Wed, 28 Sep 2022 14:12:40 GMT

Sorry about that! I forgot to include the definition here: I have updated the post to include PatrolDateCalc = datetime.date(2022, 9, 19).

Re: How to add a date field and custom date?

nsidaniel — Wed, 28 Sep 2022 14:13:29 GMT

Thank you for responding! Yep, PatrolDateCalc is defined in my code, but I forgot to put it here. I've updated the post to include PatrolDateCalc = datetime.date(2022, 9, 19).

Re: How to add a date field and custom date?

dgiersz_cuyahoga — Wed, 28 Sep 2022 14:40:41 GMT

Try using PatrolDateCalc = datetime.datetime(2022, 9, 19)

Re: How to add a date field and custom date?

RogerDunnGIS — Thu, 06 Oct 2022 15:23:15 GMT

I don't often use the arcpy version of CalculateField, but I have three thoughts and ideas:

Perhaps the "expression" parameter needs to be a string because I think another Python within arcpy has to eval() it. Perhaps the expression parameter literally needs to be "datetime.date(2022, 9, 19)" instead of referencing a variable.
If I am correct about the expression parameter, and you still want to use a variable as the date, perhaps you could pass in "datetime.date({0}, {1}, {2})".format(PatrolDateCalc.year, PatrolDateCalc.month, PatrolDateCalc.day) instead
Is it a problem having a new field called DATE? Sometimes this is a keyword in SQL databases

Let us know and good luck!

Re: How to add a date field and custom date?

RogerDunnGIS — Thu, 06 Oct 2022 16:11:32 GMT

Here is what worked for me on a file geodatabase on a field declared with the Date type:

arcpy.management.CalculateField(myLayer, myField, "'{0}'".format(PatrolDateCalc.strftime("%m/%d/%Y")))

Note that you may want (or even need) to change the parameter to strftime to match your locale better. I don't know.

Let us know and good luck!