AnsweredAssumed Answered

Start/Stop date itinerary

Question asked by NikolajThestrup on Oct 10, 2011
Latest reply on Oct 11, 2011 by NikolajThestrup

Title

Start/Stop date itinerary

Post

Okay here we go:

cant figure this out, I need to build a travel itineray from a booking list based on start/end dates

each related record contains a start date and end date.

iam able to list every related record using "list" as this:


Monday 11/07/2011 19.30
Monday 11/07/2011 20.55
Flight

Monday 11/07/2011 21.55
Tuesday 12/07/2011 15.50
Flight


Tuesday 12/07/2011
Saturday 16/07/2011
Hotel


Saturday 16/07/2011
Sunday 24/07/2011
Hotel


Sunday 24/07/2011
Monday 25/07/2011
Hotel


Monday 25/07/2011 23.05
Tuesday 26/07/2011 05.50
Flight

Tuesday 26/07/2011 06.30
Tuesday 26/07/2011 08.00
Flight


It should go like this, grouped by dates

Monday 11/07/2011
19.30 Flight dep.
20.55 Flight arr.
21.55 Flight dep.

Tuesday 12/07/2011
15.50 Flight arr.
16.00 Hotel arr.

Sunday 24/07/2011
12.00 Hotel dep.
16.00 Hotel arr.

Monday 25/07/2011
12.00 Hotel dep
23.05 Flight dep

Tuesday 26/07/2011
05.50 Flight arr.
06.30 Flight dep.
08.00 Flight arr.

ANY HELP?

cheers

Outcomes