4 Replies Latest reply: Feb 13, 2018 8:38 AM by Sergii Karandin RSS

    Interval function time formats

    Sergii Karandin

      Hello everyone,

      I've read help and checked community, but couldn't quite find the answer, so would appreciate any help.

       

      How can I modify number formatting, such that Interval(timestamp1-timestamp2, 'D hh') would show not only show X XX,

      but will add text, so that result looks like: "X days XX hours"

       

      I was able to write arbitrary things in NUM using # signs, but them seem not to work in INTERVAL

       

      Thanks in advance