1 Reply Latest reply on Jan 12, 2018 3:53 PM by mesverrum

    How to convert SWQL "tostring" to number for reporting?

    alex777

      Hi all,

       

      I'm trying to find a way to convert a TOSTRING value to a number so that in my reporting I can display "order by" correctly and not in text.

      ,case when ack.timestamp is null then 'N/A'

      else tostring(minutediff(ah.TimeStamp,ack.timestamp)+0)

      end as [Minutes Until Acknowledged]

       

      Thank you!

       

      A