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

ewagstaff · ‎03-04-2022

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-ti...

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.

nutscrewbolt

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

ewagstaff

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.