|Submitted||Oct 17, 2007|
|Modified||Jan 25, 2018|
|Applies To||ArcGIS for Desktop|
|Version Found||No Version Found|
|Status||Not in Current Product Plan|
Select query based on date field fails when joining a database table to a feature layer or coverage.
No Public Explanation
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.