Error: There was a problem selecting
This error message occurs when trying to select date fields with “DATE_FIELD” = 1/8/1902:
“There was a problem selecting”
The unique value list does not display the proper date format to use for the selection.
This error also occurs anytime an incorrect SQL syntax is used.
Solution or Workaround
Use the proper date format for your data. Click the Help button on the Select by Attribute dialog box to determine the correct date format.
Coverage, Shapefile and SDE data:
DATE_FIELD = date '1776-7-4'
DATE_FIELD = #4/7/1776#
Also, make sure you have the proper SQL syntax.