Bug
When writing a definition query in ArcGIS Pro on a feature class from a SQL Server database, and the DATEDIFF function is used, the query fails if there are no records returned.
| Bug ID Number | BUG-000126459 |
|---|---|
| Submitted | October 31, 2019 |
| Last Modified | May 16, 2025 |
| Applies to | ArcGIS Pro |
| Version found | 2.4.2 |
| Operating System | N/A |
| Operating System Version | N/A |
| Status | Non-Reproducible |
Additional Information
This issue is no longer reproducible. When no records are found, the validation process returns a warning, and that is expected.Workaround
- Avoid using the DATEDIFF SQL function in the definition query. For example, 'Date<(GETDATE()-1)'.
- Alternatively, use the same expression in ArcMap instead.
Steps to Reproduce
Bug ID: BUG-000126459
Software:
- ArcGIS Pro
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