laptop and a wrench

Bug

Applying Select By Attributes on date fields of hosted feature services fails in ArcGIS Pro.

Last Published: August 27, 2018 ArcGIS Pro
Bug ID Number BUG-000111737
SubmittedFebruary 16, 2018
Last ModifiedJune 5, 2024
Applies toArcGIS Pro
Version found2.1
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusKnown Limit

Additional Information

This is a known limitation. To avoid this, users are recommend a best practice of using the BETWEEN SQL operator to perform the query using SQL rather than using ‘=’ in the query builder. This ensures accuracy and reliability. For more infomration, please contact Support Services. Use the example below of adding a second before and after the time being queried, ensuring that the first timestamp precedes the second one. last_edited_date BETWEEN TIMESTAMP '2018-09-24 20:10:53' AND TIMESTAMP '2018-09-24 20:10:55'

Steps to Reproduce

Bug ID: BUG-000111737

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options