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.
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#