Interval over the line

[1adam_haj]

How to deal with wrong format of data ?

I have a table like this

Time 1	Time 2	Interval
2.1.2017 20:00	2.1.2017 21:00	Interval between Time2-and UpperTime1
1.1.2017 20:00	1.1.2017 21:00	Interval 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]

[MarcoARaymundo]

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;