7 Replies Latest reply on Mar 2, 2017 1:21 PM by philmodjunk

    Need assistance with my Elaspsed date/time calculation

    xxx202xxx

      Hi All,

       

      I am currently calculating how long a service ticket has been open in days.

       

      Let ( Stop = If ( IsEmpty ( Date_Closed ) ; Get ( CurrentDate ) ; Date_Closed ) ; Ceiling (stop - Date_Created ) )

       

      I now would like to change that to hours.  So would by new calc be:

       

      Let ( Stop = If ( IsEmpty ( Time_Closed ) ; Get ( CurrentTime ) ; Time_Closed ) ; Ceiling (stop - Time_Created ) ) or

       

       

      Let ( Stop = If ( IsEmpty ( Time_Closed ) ; Get ( CurrentTimestamp ) ; Time_Closed ) ; Ceiling (stop - Time_Created ) )

       

      Thanks