I was going to send you to a similar link. We’ll look into if it makes more sense to use a UTC-style date when outputting device data, instead of the Epoch timestamp.
In the meantime, if you’d like to convert the entire file at once, you can convert the CSV to an Excel format and drop in a column with a formula.
Here’s a video on how to do that:
Note, instead of the formula they give in the video, use this one instead since we output in milliseconds instead of seconds:
((CELL + 3600000 × −4)÷86400000)+DATE(1970,1,1)
The -4 is the timezone offset. If you’re currently in Eastern time, leave it as is. For Central time, use -5, etc. An example file is attached.
date-time-example.zip (7.1 KB)