Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

Excel resport: Timestamps format

4 Posts 3 Posters 1.5k Views 3 Watching

Log in to reply

F Offline

freddygl3
last edited by

Why it has that format? how can i change it?
1 Reply Last reply
Reply Quote 0
C Offline

CraigWeb
last edited by

Hi @freddygl3

In excel set the column format to date or time and save it then re-upload it to your report.
1 Reply Last reply
Reply Quote 0
I Offline

iperry
last edited by

Hi freddygl3

I had the same issue. It was resolved by putting 2 "dummy" records with the fields formatted the way you want.

https://forum.infiniteautomation.com/topic/3906/unusual-timestamp-value-in-rollup-excel-report

Thanks
Ian
1 Reply Last reply
Reply Quote 0
F Offline

freddygl3
last edited by freddygl3

thanks for the answers, @CraigWeb @iperry it work!
1 Reply Last reply
Reply Quote 0

1 / 1