AnsweredAssumed Answered

Date field in Excel to Table tool

Question asked by jborgion Champion on Apr 3, 2019
Latest reply on Oct 14, 2020 by ren_rosin

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....