Use only date from Datetime in arcpy.SelectLayerByAttribute_management

JeffHouser

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

JeffHouser

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