Excel resport: Timestamps format | Mango

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).

F
freddygl3

Excel resport: Timestamps format

Why it has that format? how can i change it?
freddygl3 | , last edited by

• 0
CraigWeb

Hi @freddygl3

In excel set the column format to date or time and save it then re-upload it to your report.
CraigWeb | , last edited by

• 0
I
iperry

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
iperry | , last edited by

• 0
F
freddygl3

thanks for the answers, @CraigWeb @iperry it work!
freddygl3 | , last edited by freddygl3

• 0

Posts 4 • Views 683