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

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

    Paul M



      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.