2 Replies Latest reply: Feb 12, 2014 11:29 AM by Quy Thanh Lê RSS

    Script difference timestamp calculation

      Hi,

       

      I load datas from a database, where there are several timestamps

      example :

      [Field 1] [Date/Time Departure 1] [Date/Time  Arrival 1],

      [Field 2] [Date/Time Departure 2] [Date/Time  Arrival 2],

      [Field 3] [Date/Time Departure 3] [Date/Time  Arrival 3], etc.

       

      MyTable:

      LOAD

      Field,

      DateDeparture,

      DateArrival

      Resident Table;

       

      I want to add a field TimeStampDiff which is the lapstime in minutes between  [Date/Time Departure 2] and [Date/Time  Arrival 1], [Date/Time Departure 3] and [Date/Time  Arrival 2]

      In general [Date/Time Departure n+1] and [Date/Time  Arrival n]

       

      How can I do it in script ?

      Thanks in advance for your help