LastLogonTimeStamp

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Larry Lim - 21 Jun 2005 12:57 GMT

Hi,

I need help in converting the figures extracted by CSVDE in Excel format.
I can't seem to figure out the formula to convert the figures into Date
format in Excel. I can't run it entry by entry as there are too many
accounts to check.

Does anyone has an Excel formula to convert it to date?
Example: 12345678E+12 to Date in Excel.

Please help.

Thank you very much.
Larry

Reply to this Message

Lesley Kipling [MSFT] - 27 Jun 2005 17:59 GMT

Hi.

A couple of options to convert from this filetime format to regular dates..

Use w32tm: for instance w32tm /ntte 127202682170621000

Or, if you want to convert more than one value, use a programmatic method
you can loop into the spreadsheet.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/swbe
mdatetime.asp

HTH, Les

This posting is provided "AS IS" with no warranties, and confers no rights.

> Hi,
>
[quoted text clipped - 10 lines]
> Thank you very much.
> Larry

Reply to this Message