• Recent
    • Tags
    • Popular
    • Register
    • Login

    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

    Scheduled Pinned Locked Moved User help
    4 Posts 3 Posters 1.5k Views 3 Watching
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • F Offline
      freddygl3
      last edited by

      0_1549419742074_timestamps.PNG

      Why it has that format? how can i change it?

      1 Reply Last reply Reply Quote 0
      • CraigWebC 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
            • First post
              Last post