NetBotz History Export date is seen as a Linux Time Stamp
Issue:
NetBotz History Export date is seen as a Linux Time Stamp.
Product Line:
NetBotz
Environment:
NetBotz History Export.
Cause:
NetBotz is based on the Linux operating system and as such much of it's data uses a Linux Time Stamp The Exported data may look something like this:
"Sensor Pod (integrated)";"Temperature";"1465097276057";"30.00"
Resolution:
It is unlikely this will be changed in a future revision so if it is necessary to view this as a date, the information can always be imported into a spread sheet application such as Microsoft Excel.
I can translate 1465097276057 on the epochtime.com page but in Microsoft Excel, the number does not translate easily. I must delete the last 3 digits just to be able to use the suggested Excel formulae:
=(((C2/60)/60)/24)+DATE(1970,1,1)<br />
or
=C2/(60*60*24)+"1/1/1970"
You can also cut off the rest of the numbers by using a formula like this:
=(((LEFT(C2,10)/60)/60)/24)+DATE(1970,1,1)
When formatted properly using a time format, the result should look like this:
6/5/16 3:27 AM