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
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.
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.
This is the case in newer versions of Pro.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.