How to convert 18 digit time stamp to readable format

[markthor123]

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?

[patrick_digan · Accepted solution]

@markthor123 Try this in a formula tool:

DateTimeAdd("1601-01-01",[Field1]/10000000+1,"seconds")

[markthor123]

That worked like a charm!  Thank you @patrick_digan for your quick response!