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

User help

3

4

1.1k

Log in to reply

F

freddygl3
last edited by

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

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

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

freddygl3
last edited by freddygl3

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

1 / 1