Interval over the line

1adam_haj — Fri, 20 Oct 2017 19:04:53 GMT

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]

Re: Interval over the line

MarcoARaymundo — Sat, 21 Oct 2017 14:10:41 GMT

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;