AnsweredAssumed Answered

Convert 5 digit date serial number to MM/DD/YYYY

Question asked by lampe.phil on Apr 1, 2016
Latest reply on Apr 2, 2016 by Dan_Patterson

Hello,

 

I have a string field (named StartDate) in an attribute table that contains numerous 5 digit (post 1900, Excel style) values (such as 40,240) that I need to convert into into a readable date format (which in this case would be MM/DD/YYYY).

 

I have created an empty field named StartDateDT to house the converted serial dates.  The field is in DATE format.

 

What is the code in VB (preferred) or python to do this?

 

I am using ArcMap 10.22, standard (aka ArcEditor) license, BTW.

 

Many THANKS in advance!

 

Phil in Houston

Outcomes