• 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 4 Documentation Website Mango 5 Documentation Website Radix IoT LinkedIn

    Excel resport: Timestamps format

    Scheduled Pinned Locked Moved User help
    4 Posts 3 Posters 1.9k 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

            Hello! It looks like you're interested in this conversation, but you don't have an account yet.

            Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.

            With your input, this post could be even better 💗

            Register Login
            • First post
              Last post