Question & Answer
How to convert date values in CSV (comma separated values) exported reports from RAW format to a human readable format ?
When exporting Tivoli Storage Manager - Data Protection for VMware GUI reports with version 7.1.1 or higher in CSV format, the date values are in RAW format.
This means that the date values are expressed in milliseconds and in Unix time (a.k.a. POSIX time or Epoch time) which is the time elapsed since 00:00:00 Coordinated Universal Time (UTC) on 1 January 1970.
To translate the dates using spreadsheet tools, the following needs to be done :
To get the UTC time insert in the spreadsheet cell :
Then edit the cell properties to tell it is a date format and you will get the UTC time in human readable format.
To adjust it for another timezone, add or subtract the number of hours (in seconds) relative to UTC :
For example to subtract 2 hours, the formula is :
17 June 2018