1 Reply Latest reply: Oct 21, 2017 10:10 AM by Marco Antonio Raymundo RSS

    Interval over the line

    Adam Hájek

      How to deal with wrong format of data ?

       

      I have a table like this

       

      Time 1Time 2Interval
      2.1.2017 20:002.1.2017 21:00Interval between Time2-and UpperTime1
      1.1.2017 20:001.1.2017 21:00Interval between Time2-and UpperTime1

       

      How can i calculate Interval between Time 2 ( Lower line )  and Time 1 ( Upper line  )

       

      I tried this, but red line didnt give any result ... the formated times are displayed good.

       

       

      data:

      Load

      *,

      [Formated Time 2] - peek([Formated Time 1]) as Difference;

      Load

      RecNo() as Index,

      date#([Time 1],'M.D.YYYY hh:mm') as [Formated Time 1],

      date#([Time 2],'M.D.YYYY hh:mm') as [Formated Time 2]

        • Re: Interval over the line
          Marco Antonio Raymundo

          data:

          LOAD

               *,

               [Formated Time 2] - Previous([Formated Time 1]) as Difference;

               LOAD

                    RecNo() as Index,

                    date#([Time 1],'M.D.YYYY hh:mm') as [Formated Time 1],

                    date#([Time 2],'M.D.YYYY hh:mm') as [Formated Time 2]

               FROM SourceFile;