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.
Hi @ewagstaff. Has this issue resolved? I am facing the same issue
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.