laptop and a wrench

Bug

Using the mm/dd/yyyy or mm-dd-yyyy date format in Field Calculator returns incorrect dates.

Last Published: November 1, 2019 ArcGIS for Desktop
Bug ID Number BUG-000126235
SubmittedOctober 23, 2019
Last ModifiedFebruary 18, 2025
Applies toArcGIS for Desktop
Version found10.7.1
Operating SystemN/A
Operating System VersionN/A
StatusWill Not Be Addressed

Additional Information

The Field Calculator parser does not accept literal dates as valid input for date fields. To make this calculation, use the cdate function using VB Script. Optionally, calculate using a string: '10/4/2019'. Please see the help documentation here: https://desktop.arcgis.com/en/arcmap/latest/manage-data/tables/fundamentals-of-date-fields.htm#ESRI_SECTION1_31F23E610D334618B1BD9871419B6EF3

Steps to Reproduce

Bug ID: BUG-000126235

Software:

  • ArcGIS for Desktop

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options