2 Replies Latest reply: Nov 7, 2017 12:09 PM by JAIRO FERNANDO RSS

    Timstamp Intervals

    ilan baruch

      hi all,

      trying to calculate duration in minutes between 2 Timstamps

      create Timstamp in script as below:


      Timestamp(StartDate&' '&StartTime,'YYYYMMDD hh:mm') as StartStamp,

      Timestamp(EndDate&' '&EndTime,'YYYYMMDD hh:mm') as EndStamp,


      calculating interval in both script and layout as below


      and looks ok but,

      when there is a day deference result comes bad... i.e :


      end stamp = 20171105 00:01

      start stamp = 20171104 23:56


      endstamp - startstamp retrieves   :  -23:54 from script calculation


      216:06 in layout calculation


      where the result is 00:06.....


      would appreciate your help,

      advanced thanks