2 Replies Latest reply: Jan 24, 2017 8:41 AM by Paul M RSS

    Adding custom strings to formats (interval, date, time)

    Paul M

      Hi,

       

      I'm using the interval function to work out the period between two datetime values, in days and hours, as below:

       

       

      Interval(ReloadTime() - L_DispatchRequestTime, 'd - hh')

       

       

      Whilst this gives the correct results it looks very confusing. I'm looking to add my own custom labelling to the format so I can something like:

       

      '1 day 5 hours'

       

      Is there any way of adjusting the formatting so I can fully customise the labelling, or get the result above?

       

      Thanks in advance.