There was a problem selecting

Last Published: April 25, 2020

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.

Article ID:000002822

  • ArcMap 8 x

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic