I have exported bpimage data
I have exported bpimage data to a text file and then imported into an excel sheet but when trying to sort the backup or expiry date in ascending or descending excel sees a large number approx 60% of the data as text rather than date. I have tried all sorts of formatting techniques and some from microsoft tech sites but have had no luck. I am wondering why the netbackup export has two types of formats in the data related to the dates.
We have moved this to a new discussion from https://www-secure.symantec.com/connect/forums/how-can-we-export-netbackup-configuration-excel as your query is not related to that particular post.
The 2nd post could not be moved with above post and can be seen here: https://www-secure.symantec.com/connect/forums/how-can-we-export-netbackup-configuration-excel#comment-11384111
My colleage has used the Image Timestamp (column K in our spreadsheet) to calculate the backup time.
Formula in new column (row 2):=K2/(60*60*24)+25569
So, 1433614916 works out to be 06/06/2015 18:21:56
Column format is Number with Custom format: dd/mm/yyy hh:mm:ssHope this helps.
