TOOLTIKI Lovable tool, really free
Date & time Timestamps

Date to Windows FILETIME

Value
Direction
Epoch system
Result 133485408000000000
Readable Mon, 01 Jan 2024 00:00:00 GMT
ISO 8601 2024-01-01T00:00:00.000Z
JavaScript Date Mon Jan 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
Date only 2024-01-01
Time only (UTC) 00:00:00
Unix seconds 1,704,067,200
Unix milliseconds 1,704,067,200,000
Windows FILETIME 133,485,408,000,000,000
.NET ticks 638,396,640,000,000,000
Excel serial 45,292
Mac HFS+ seconds 3,786,912,000
Note
Local · 0 means never in Active Directory
Advertisement
320 × 100

Converts a date into a Windows FILETIME — 100-nanosecond intervals since 1 January 1601 UTC. This is the value in file timestamps, the registry and Active Directory.

How to use the date to windows filetime

1 Paste a date — ISO 8601, "2024-01-01 12:00:00", or the string a JavaScript Date prints.
2 Switch the direction to go the other way — the same page converts both ways.
3 All times are UTC — convert to your own zone separately if you need local time.

The 1601 epoch looks arbitrary and is not. The Gregorian calendar repeats on a 400-year cycle, and 1601 is the start of the first full cycle after the calendar was adopted in 1582 — choosing it means the day-of-week and leap-year arithmetic is a clean cycle from the epoch rather than a special case. It also comfortably predates any date a computer would need to store.

FILETIME shares its 100-nanosecond unit with .NET ticks but not its epoch, which is a genuinely dangerous similarity: two large numbers in the same unit, 504 years apart. Confusing them produces a date that is wrong by exactly 1,600 years, and the offset between them is 504,911,232,000,000,000.

Where you meet this is Active Directory, and it has a quirk worth knowing: accountExpires and lastLogonTimestamp use FILETIME, but the value 0 and the value 9223372036854775807 both mean "never" rather than an actual date. Converting either literally gives 1601 or the year 30828, and code that does not special-case them produces exactly those nonsense values in reports.

Questions

It is the start of the first full 400-year Gregorian cycle after 1582, which makes the calendar arithmetic clean.

Microsoft — FILETIME structureMicrosoft — accountExpires attribute
Advertisement
300 × 250
Was this tool any good?
INTERNAL SIGNAL ONLY · WE USE IT TO FIND TOOLS WORTH REBUILDING