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.
[Formated Time 2] - peek([Formated Time 1]) as Difference;
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]