topic Querying a date field, but API does not return valid matches for exact date in ArcGIS REST APIs and Services Questions

Querying a date field, but API does not return valid matches for exact date

ewagstaff — Fri, 04 Mar 2022 19:18:49 GMT

Hi all, using the ArcGIS REST API, I am unable to do a date query that gets results for the exact date matching a feature's attribute. For example, I have a feature with "created_date": 1646417844731 (2022-03-04 around 10am Pacific Time), but if I query with a 'where' param of

created_date = DATE '2022-03-04'

it returns no features. This syntax SHOULD be working, according to the ArcGIS blog: https://www.esri.com/arcgis-blog/products/api-rest/data-management/querying-feature-services-date-time-queries/

Worth noting that the > and < operators are working exactly as expected -- both of these 'where' params return the feature I'm looking for:

created_date < DATE '2022-03-05' created_date > DATE '2022-03-04'

Should I not be using the = operator to find today's matches? Please let me know if you can spot the error here.

Re: Querying a date field, but API does not return valid matches for exact date

nutscrewbolt — Mon, 01 Jul 2024 01:33:21 GMT

Hi @ewagstaff. Has this issue resolved? I am facing the same issue

Re: Querying a date field, but API does not return valid matches for exact date

ewagstaff — Mon, 01 Jul 2024 03:33:10 GMT

Hey! Haven't tried recently, but the solution for me was just using greater than AND less than to get a larger set of dates and then getting exactly what I needed by parsing the date attribute myself.

Re: Querying a date field, but API does not return valid matches for exact date

AaronKoelker — Tue, 12 May 2026 19:50:31 GMT

I'm having the same issue, using the ArcGIS API for Python and the .calculate() operation on a Feature Layer. I'm trying to recalculate records where the date field should be null/None but instead came into the service as 1969-12-31 19:00:00.000. Using > or < returns results, but using = does not. Using == doesn't work either (and throws an error)

Using the where query below works fine for me in this instance, but it would be nice to know how to query for an exact match in the future.

featureLayer.calculate(where = "last_login < timestamp '1970-01-01 00:00:00.100'", calc_expression = {'field': 'last_login', 'value': None})