topic Re: Selecting Features by Date in Python Questions

Selecting Features by Date

MikeEdwards — Sat, 11 Dec 2021 17:29:50 GMT

I'm trying to select all the features in a feature class that have been edited in the past day. I'm using SelectLayerByAttribute_management and I keep getting an error on the SQL query and was hoping someone could give me a hand.

In the code below lyr is the feature class being evaluated and MOD_DATE is the date field being checked.

yesterday = date.today() - timedelta(1)
yesterdaysDate = yesterday.strftime("%m/%d/%y %I:%M:%S")

SQL_statement = "MOD_DATE >= 'yesterdaysDate'"
arcpy.MakeFeatureLayer_management(lyr, "FEATURE_SELECTION")
arcpy.SelectLayerByAttribute_management("FEATURE_SELECTION", "NEW_SELECTION", SQL_statement)‍‍‍‍‍‍

Re: Selecting Features by Date

RandyBurton — Mon, 13 Nov 2017 22:39:16 GMT

Try:

SQL_statement = "MOD_DATE >= '"+yesterdaysDate+"'"‍‍‍

And, noting Joshua Bixby‌'s comment below, you may need to proceed your date with the word "date" (if using a file geodatabase, for example):

SQL_statement = "MOD_DATE >= date '"+yesterdaysDate+"'"‍

Re: Selecting Features by Date

JoshuaBixby — Mon, 13 Nov 2017 23:45:37 GMT

Seeing I don't know what back-end database is hosting your data, I can't offer a specific suggestion. In general, dates and times are handled differently depending on the back-end database: SQL reference for query expressions used in ArcGIS—Help | ArcGIS Desktop

Re: Selecting Features by Date

TinaMorgan1 — Mon, 13 Nov 2017 23:58:50 GMT

What is the underlying database, and what is the error?

Re: Selecting Features by Date

MikeEdwards — Tue, 14 Nov 2017 13:13:33 GMT

The feature classes are being pulled in through an SDE connection to an Oracel database.

Re: Selecting Features by Date

MikeEdwards — Tue, 14 Nov 2017 13:22:32 GMT

Thank you very much. The second statement worked.