Table to Excel and the Date Field

LakshmiSankaran

We just noticed that when exporting an (ArcSDE 10.7.1) feature class table to excel, using the Geoprocessing Tool Table to Excel, all date attributes converted correctly except dates that were entered as 1/1/1800. Those errored out as a negative number -36523. This was true using ArcCatalog 10.7.1 or ArcGIS Pro 2.7.3.

Any reason why?

Thanks

Lakshmi Sankaran

JoeBorgione

From the linked post:

Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39,447 days after January 1, 1900.

So your 1/1/1800 is a negative number in the microsoft serial calendar although it's hard saying why it converts to -36523 and not just -365. You may need to change those dates to1/1/1900 and see if it works out for you.