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

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options