Date to LDAP timestamp (Active Directory)
Pick a date, time and zone to get the number for an LDAP query, such as finding accounts that have not logged on since a given date.
Loading the tool…
Processing and privacy: The result is calculated inside your browser and your data is not sent to any server.
How to use it
- Enter date, time, seconds and time zone of the date entered.
- The result appears straight away and updates as you edit.
- Copy the result, or copy a link that keeps the same values to share it.
How it is calculated
Value = (Unix seconds + 11644473600) × 10000000, the count of 100-nanosecond intervals since 1601-01-01 00:00:00 UTC.
Example
Inputs: Date = 2026-10-01, Time = 00:00, Seconds = 0, Time zone of the date entered = UTC. Result: LDAP timestamp: 134352864000000000.
Limits and caveats
- For accountExpires, Active Directory uses the start of the day after the last valid day, so enter that day if needed.
- Zone offsets and daylight saving come from your browser time-zone database and can differ for very old dates.
Questions about this tool
How do I find accounts inactive since a date?
Get the value for that date, then use a filter such as (lastLogonTimestamp<=value) in your LDAP query.
Do I need to convert the time zone?
Yes, the value is always UTC. Pick your zone and the offset is applied for you.
Is this the same as FILETIME?
Yes, it is the same format, and the hex value shown is that number as a FILETIME.