The 18-digit Active Directory timestamps, also named 'Windows NT time format' and 'Win32 FILETIME or SYSTEMTIME'. These are used in Microsoft Active Directory for pwdLastSet, accountExpires, LastLogon, LastLogonTimestamp, and LastPwdSet. I would like to convert this date into something that is readable.
For example, I have 130256633677812490 which should turn into GMT: Monday, October 7, 2013, 11:49:28 PM.
How can I achieve this in Alteryx?
Gelöst! Gehe zu Lösung.
That worked like a charm! Thank you @patrick_digan for your quick response!