Query items from today's date using Python API

3CDCOrganizationalAccount — Fri, 19 Nov 2021 21:53:46 GMT

I am not sure if this is the correct spot to ask this question, but I am trying to write code to query features created during today's date. I have figured out querying works in general;

from datetime import date
today = date.today()
query1 = Assignments.query(where="Status = 3")
query1

<FeatureSet> 29 features

But I am unsure how to do this with date types. Any suggestions?

Thanks!

Re: Query items from today's date using Python API

jcarlson — Fri, 19 Nov 2021 22:32:30 GMT

It can depend on the database that you're querying. If it's an enterprise geodatabase, see the reference page for how to query each of them.

In general, however, you can write the query as follows.

Assignments.query(where=f"EditDate_1 <= date '{datetime.date.today()}'")

topic Query items from today's date using Python API in ArcGIS API for Python Questions

Query items from today's date using Python API

Re: Query items from today's date using Python API