Received an error when doing definition query on a ‘date’ field of a joined table using the getdate() function.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM010996
Submitted
August 15, 2007
Last Modified
April 2, 2025
Applies to
No Product Found
Version found
9.2
Status
Non-Reproducible
This issue was not reproducible when tested by the development team. Issues may be given this status when they cannot be reproduced or are no longer relevant in a development version of the software, but a specific fix was not installed to address the issue. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
1. Export the joined table to sde and run the definition query on the newly created table2. Create a spatial view based on the two tables and run the definition query on the spatial view