Select query based on date field fails when joining a database table to a feature layer or coverage.
Last Published: November 30, 2015No Product Found
Bug ID Number
NIM012414
Submitted
October 17, 2007
Last Modified
April 28, 2025
Applies to
No Product Found
Version found
9.2
Status
Known Limit
After review by the development team, it has been determined that this issue is related to a known limitation with the software that lies outside of Esri's control. The issue's Additional Information section may contain further explanation.
Additional Information
No Public Explanation
Workaround
Exported the joined attribute table as a standalone dbf table and store it in local drive will work with problem.
*Append the query on the joined table to include a statement for a target table field, (the example that follows uses fake table and field names) : jointable.joinfield = date '2002-05-20' AND targettable.targetfield IS NOT NULL
*If data are stored in enterprise databases, create a spatial view to join the table and the feature class. Then perform Select query on the spatial view.