Things big and small IT related

For a successful technology, reality must take precedence over public relations, for nature cannot be fooled. (Richard P. Feynman)

Friday, 7 February 2014

Converting LDAP timestamp

EXCEL FORMULA

Taken from: https://social.technet.microsoft.com/wiki/contents/articles/12814.active-directory-lastlogontimestamp-conversion.aspx

=IF(C2>0,C2/(8.64*10^11) - 109205,"")

Date to timestamp

In PowerShell:

(Get-Date "1/11/2013").ToFileTime()

Timestamp to date:

From the command line:

w32tm.exe /ntte 130277628000000000

Posted by Arthur Dali at 12:26 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Blog Archive

  • ►  2018 (5)
    • ►  June (2)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ►  2017 (3)
    • ►  October (1)
    • ►  September (1)
    • ►  March (1)
  • ►  2016 (1)
    • ►  February (1)
  • ►  2015 (2)
    • ►  October (1)
    • ►  April (1)
  • ▼  2014 (1)
    • ▼  February (1)
      • Converting LDAP timestamp
  • ►  2013 (7)
    • ►  December (1)
    • ►  August (2)
    • ►  May (1)
    • ►  February (1)
    • ►  January (2)
  • ►  2012 (7)
    • ►  December (1)
    • ►  October (1)
    • ►  September (5)
Simple theme. Powered by Blogger.