How to format fields in CSVDE csv dump to display as a date?

  • Thread starter Thread starter Cappy
  • Start date Start date
C

Cappy

Hello!

I have run a CSVDE dump of all of the "users" in our Windows2000 domain. One of
the items we are interested in tracking is the lastLogon. When I import the
output of the dump in to Excel, the values in the lastLogon column are displayed
in this format:

1.27652E+17


The cell type in the spreadsheet is "General."

If I change the format of the cells in the column to "Number," I get this:

127651540246987000


(This is also the string that is in the output file.)

This is not a UTC date, this particular string of digits translates to Dec 27,
2007. Although, I don't think my little UTC translator understands all of those
digits. 1270000000 translates to Mar 30 2010. grin

If I format the cell to date, I get a string of # signs.

The whenChanged and whenCreated fields come in as recognizable dates, although
they do have a .0Z "extension."

Any help formatting the CSVDE dump would be greatly appreciated.


Cappy
 
Might also suggest www.joeware.net Possibly because I always forget to
suggest it, but also because there would be no script writing/customization.
It's an .exe vs. a script. Either would be helpful.

You *could* likely take some of that information and use it to convert the
output in the Excel file, but why take the extra step?

Al
 
Back
Top