Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Use the Previous or Peek functions to calculate the difference.
ArrivalTime - Previous(ArrivalTime)
Please post some sample source data so community will help more.
Use the Previous or Peek functions to calculate the difference.
ArrivalTime - Previous(ArrivalTime)
Please post some sample source data so community will help more.
Thank you, it seems to work !
I'll try next time to add sources. Please see my other topic : Filter a table object with a calendar