AnsweredAssumed Answered

Date field in Excel to Table tool

Question asked by jborgion Champion on Apr 3, 2019
Latest reply on Apr 3, 2019 by jborgion

I was given a couple of excel spreadsheets to geocode and have just realized that there is a date field in the spreadsheets that got converted to a text field with the excel to table tool (ArcGIS Pro 2.3.1).  Is there any correlation between the string values and a real date?

 

For example: Excel date 5/8/2003 = 37747 Pro string and Excel date 6/9/2003 = 37777 Pro String....

Outcomes