laptop and a wrench

Bug

Select query based on date field fails when joining a database table to a feature layer or coverage.

Last Published: November 30, 2015 No Product Found
Bug ID Number NIM012414
SubmittedOctober 17, 2007
Last ModifiedApril 28, 2025
Applies toNo Product Found
Version found9.2
StatusKnown Limit

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.

Steps to Reproduce

Bug ID: NIM012414

Software:

  • No Product Found

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options