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, the records it does convert it gives me the wrong date. Is there any way I can work around this?
I'll include a screenshot of what I'm looking at.
3 Replies
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.
the source field is not a whole number (remember there are time zones involved). Also, what message do you get when clicking on the Error link?
Hi kayla22 ,
Could you please provide some sample data from the column user.accountExpires in order to make troubleshooting? And please provide the original values with error and the related error message. Thank you.
In addition, please refer the method in the following links to create some custom columns to get the new date column and check whether it can help you resolve the problem.
Convert Integer value to Date format in Power BI
Best Regards
