AnsweredAssumed Answered

What is the required format for dates in Field calculator in ArcGIS 10.3.1

Question asked by nomisc on Aug 12, 2019
Latest reply on Aug 21, 2019 by nomisc

This may seem like a simple question, but I'm having problems. According to the "Fundamentals of date fields" in ArcGIS 10.3.1, " a shapefile stores dates in a date field with this format: yyyy-mm-dd". However, when I put 2017-03-07 into my field, formatted as a date field, in Field Calculator, what comes out is 29/06/1905! If I just enter that into the individual field, it works fine, just not in the field calculator, and unfortunately I need to populate a number of shapefiles, each with several hundred rows.

 

What am I doing wrong?

Outcomes