Excel to Table Date Conversion

Idea created by jborgion Champion on Apr 3, 2019
    Reviewed
    Score80
    • lcecil5
    • Kun.Dong@vdot.virginia.gov_VDOT
    • deleted-user-8TJ6jZDO1Rfr
    • RobinRKuharski
    • billfox
    • MervynLotter
    • jborgion
    • jewel6580

    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