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”

Cause

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.

Article ID:000002822

Software:

ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

There was a problem selecting

Error Message

Cause

Solution or Workaround

Discover more on this topic