LDAP, Active Directory & Filetime Timestamp Converter

Home » Active Directory Pwdlastset Convert To Date Excel » LDAP, Active Directory & Filetime Timestamp Converter

Maybe your like

There are at least 2 types of LDAP timestamps, an 18-digit timestamp and a timestamp that is based on a Year-Month-Day format.

Convert 18-digit LDAP/FILETIME timestamps to human-readable date

The 18-digit Active Directory timestamps, also named 'Windows NT time format', 'Win32 FILETIME or SYSTEMTIME' or NTFS file time. These are used in Microsoft Active Directory for pwdLastSet, accountExpires, LastLogon, LastLogonTimestamp, and LastPwdSet. The timestamp is the number of 100-nanosecond intervals (1 nanosecond = one billionth of a second) since Jan 1, 1601 UTC.

The current LDAP/Win32 FILETIME is 134168556680000000 or in scientific notation 13416855668e7.

Enter number in full or in scientific/exponential notation: Milliseconds are discarded (last 7 digits of the LDAP timestamp)

Convert 18-digit LDAP to date

Create an 18-digit LDAP timestamp

YrMonDay
--
HrMinSec
: : AMPMGMTLocal time
Create LDAP timestamp

Other converters & programming

Microsoft Windows

In Windows (command line) use: w32tm.exe /ntte 131001091660000000

PowerShell

(Get-Date 1/1/1601).AddDays(131001091660000000/864000000000)

Convert YMD LDAP timestamps

These LDAP timestamps are much simpler and start with the year. The timestamp has the following format: YYYYMMDDHHMMSST. T is the time zone which is usually 'Z' (Zulu Time Zone = UTC/GMT). The tool below can only handle Zulu timestamps.

The current YMD timestamp is 20260301162108Z

Enter your timestamp:

Convert YMD LDAP to human date/epoch

Comments and questions

Show comments

Tag » Active Directory Pwdlastset Convert To Date Excel