topic Re: Use only date from Datetime in arcpy.SelectLayerByAttribute_management in ArcMap Questions

Use only date from Datetime in arcpy.SelectLayerByAttribute_management

JeffHouser — Mon, 09 Oct 2023 19:09:04 GMT

I'm defining a SetQuery variable in Arcpy.SelectLayerByAttribute_management(fc, 'NEW_SELECTION', SetQuery) as

SetQuery = 'chgdate > admin_date'. Both chgdate and admin_date are fields in the featureclass. However, the chgdate is datetime, and admin_date is date fieldtype. For the results from the Arcpy.SelectLayerByAttribute_management, I would like the SetQuery be based on where the chgdate values are of the date field type (not include time).

Is there a way to do this?

-Jeff

Re: Use only date from Datetime in arcpy.SelectLayerByAttribute_management

Kara_Shindle — Mon, 09 Oct 2023 20:33:51 GMT

How are you processing your data? Can you post a Python snippet or something? When I need a portion of a date, I parse it using the pandas package and select the portion of the date I need & store that as a new variable.

When I do that, I use a method like this article describes

Re: Use only date from Datetime in arcpy.SelectLayerByAttribute_management

JeffHouser — Mon, 09 Oct 2023 20:43:08 GMT

Hello Kara,

Here is a code snippet that leads to the arcPy.SelectLayerAttribute_Management

fds = arcpy.ListDatasets(feature_type='Feature')

for fd in fds:

# For each feature dataset, get a list of feature classes.

fcs = arcpy.ListFeatureClasses(feature_dataset=fd)

for fc in fcs:

print ('Database: ' + fd + ' Feature Class: ' + fc)

lstFields = arcpy.ListFields(fc)

field_names = [f.name.upper() for f in lstFields]

if "ADMIN_DATE" in field_names:

# chgdate > admin_date.

SetQuery = 'chgdate > admin_date'

arcpy.MakeFeatureLayer_management(fc, fc + "_new")

# print(fc+"_New")

arcpy.SelectLayerByAttribute_management(fc + "_new", 'NEW_SELECTION', SetQuery)

...

I hope this helps to compliment my original post.

-Jeff