Query Builder does not build the proper date query when the layer has a join and all records are kept. Also, manually writing the expected SQL query for dates when joins are present doesnt work. This issue only effects Personal Geodatabases.
Last Published: August 25, 2014No Product Found
Bug ID Number
NIM001741
Submitted
March 28, 2006
Last Modified
June 5, 2024
Applies to
No Product Found
Version found
9.2
Status
Duplicate
The issue is a duplicate of an existing issue. See the issue's Additional Information section for details. Customers associated with the duplicate issue are automatically attached to the open issue.
Additional Information
NIM004401
Workaround
Use FGDB - there are no problems with above queries when using FGDB. If you must use PGDB, modify the query to be the following:FC1.date = date '01/12/2001' and Table1.OBJECTID > 0This is documented in the help: <a href="http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=257&pid=247&topicname=SQL_reference" target="_blank">http://webhelp.esri.com/arcgisdesktop/9.2/index.cfm?id=257&pid=247&topicname=SQL_reference</a>It is also documented in KB22132:<a href="http://support.esri.com/index.cfm?fa=knowledgebase.techArticles.articleShow&d=22132" target="_blank">http://support.esri.com/index.cfm?fa=knowledgebase.techArticles.articleShow&d=22132</a>