ERROR
In some instances, when using the Select Layer By Attribute tool on a layer imported from ArcGIS Online, or querying a feature in ArcGIS Pro, or attempting to open the attribute table of a feature class or a hosted feature service in ArcGIS Pro, the following error message is returned:
Error: Not a legal OleAut date.
This error occurs due to the following known causes:
Depending on the cause, choose one of the methods provided to resolve the problem.
Assign null values to the empty fields
Replace the empty field values with nulls. Refer to How To: Assign nulls to a field in ArcGIS Pro for more information.
Remove the special characters from the date field values
To remove special characters in the field value, double-click the cell, select the special characters, and press Delete on the keyboard. Optionally, set the empty field values to null. Refer to How To: Assign nulls to a field in ArcGIS Pro for steps to do so.
Correct or exclude dates earlier than January 1, 100
If the table contains datetime values earlier than midnight, January 1, 100, confirm that the values are valid and correct those that are not. If all values are correct and you cannot make changes to the data, you can do one of the following to work with the table and avoid the error message:
Get help from ArcGIS experts
Download the Esri Support App