Excel to Table Date Conversion

1683
3
04-03-2019 02:29 PM
Status: Already Offered
Labels (1)
JoeBorgione
MVP Emeritus

It would be cool if the Excel to Table encounters a Date field in Excel it does the conversion from Microsoft Date Serial format to the correct calendar date and put it in a real-live date field rather than a text field.

see:  https://community.esri.com/thread/231594-date-field-in-excel-to-table-tool

and

https://community.esri.com/thread/174953

3 Comments
LeviCecil

I'm trying to do a join right now and the date field from Excel is just coming up as a five digit number in the date field in Pro. 

JoeBorgione

Hey Levi-  if you need a solution to this, how about you start a new thread; the ideas space isn't a good one for asking questions.

JonathanNeal