ArcMap Field Calculator: ArcPy Date to Decimal Function
One of the standards in our databases is to store dates as 8-digit integer values in the format of yyyymmdd. This requires us to occasionally convert values from date fields into this format.
We can do this in the ArcMap Field Calculator using this arcpy function:
def datetodouble(inNum):
splitList = str(inNum).split("/")
return splitList [2] +("0"+ splitList [0])[-2:] +("0"+ splitList [1])[-2:]