Bug
When querying a date field of a SDE geodatabase feature class, the Select By Attribute tool in ArcGIS Pro fails to preface the date being queried with the necessary delimiter ('date').
| Bug ID Number | BUG-000110490 |
|---|---|
| Submitted | December 29, 2017 |
| Last Modified | June 25, 2025 |
| Applies to | ArcGIS for Desktop |
| Version found | 10.5.1 |
| Operating System | Windows OS |
| Operating System Version | 7.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
We apologize that we were unable to address this issue within the current product support cycle. If the issue continues to affect your work in a supported release, please contact Technical Support.Workaround
Once the query is constructed, click the ‘Switch to Edit SQL Mode’ button if not already in this view, and manually add the word 'date' in front of the date the user is selecting on.Example: Before:superhero.DATA_CREATOR.Time.Date = '2004-05-03 00:00:00' AND (Sheet1$.Name IS NOT NULL OR Sheet1$.Name IS NULL)After:superhero.DATA_CREATOR.Time.Date = date '2004-05-03 00:00:00' AND (Sheet1$.Name IS NOT NULL OR Sheet1$.Name IS NULL)Steps to Reproduce
Bug ID: BUG-000110490
Software:
- ArcGIS for Desktop
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App