1 Reply Latest reply on Nov 14, 2016 1:13 PM by Jonathan Drummey

    Datediff as DD:HH:MM:SS

    Adam Rauh

      Hey guys,

       

      I'm trying to find a way to convert the difference b/t 2 dates into a DD:HH:MM:SS format.  I can already do a regular 'day' Datediff calc. field, but I'm looking for more granularity than that.

       

       

      Ex showing how I've converted the date fields to a string to date the exact date, along w/ the Datediff already in there.  These 2 fields (opened At (copy); resolved at (copy)) are the one's I'm to do the math from that.