Error: There was a problem selecting

Error Message

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'

Access data:
DATE_FIELD = #4/7/1776#

Also, make sure you have the proper SQL syntax.