ZENworks Date/Time Dump to Excel
Articles and Tips: qna
01 Feb 2002
Q.
How do I display the dates in the ZENworks inventory in Excel? For example, if I get a person's last scan date exported out of NDS to Excel, it appears as a number such as 1003847102. How can I convert that to a date/time?
Excelling in East Bay
A.
Dear Excelling: The dates are in "Unix format," which shows date and time in seconds since 1970. Excel expect its days to be since 1900. To convert the number you see, divide that number by (60*60*24) and add the number of days between 1900 and 1970 (25568). An example of this would be: A1/(60*60*24)+25568
* Originally published in Novell AppNotes
Disclaimer
The origin of this information may be internal or external to Novell. While Novell makes all reasonable efforts to verify this information, Novell does not make explicit or implied claims to its validity.