Query items from today's date using Python API

[3CDCOrganizationalAccount]

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! 

[jcarlson]

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()}'")