Hello there - Please help......

 

 

I would like to create a field(Day_Count) that determines the day number(in red font) of a Trip/Visit record. Given the following records for the trip identified as 14CHACAP00214:

PLACE                      DATE_IN                DATE_OUT                NIGHTS          DAY_Count

Safari Camp            Date in: 11.03.2014 Date Out: 13.03.2014 Nights: 2       DAY 1

Cost Dunes             Date in: 13.03.2014 Date Out: 13.03.2014 Nights: 0       DAY 3

Mokuti Lodge          Date in: 13.03.2014 Date Out: 14.03.2014 Nights: 1       DAY 3

Gross Barmen         Date in: 14.03.2014 Date Out: 18.03.2014 Nights: 4       DAY 4

 

How do i implement a calculation for this result - or what solution will work for this scenario?

 

Many thanx for all suggestions/opinions,

Miss A!

 

 

 

Is there a StartDate field in the parent record?

Yes there is a date When the trip starts and a date when the trip ends.

Well, then subtract the StartDate of the parent trip from the DateIn of the itinerary item (?) and add 1.

Edited May 28, 201510 yr by comment

Yes Yes Thank you - got idea from your first suggestion, was not trusting what i made of it simply because just(most times i do not know what am doing).