Forum Discussion
Active Directory Account Expires Field
I'm trying to convert the accountExpires field in Active Directory from a whole number to time/date data type. It's only converting maybe 20 records and then giving me an error for the rest. However,...
Before converting to Date/Time/Timezone, first right-click on one of the cells that contains 9.22337E+18, and choose Replace Values. Then enter null in the "Replace With" field. You should now see those values replaced with null, and you should be able to convert the column to Date/Time/Timezone.