### Title

Dates: calculating elapsed time

### Post

Am building a satabase that's essentially a timeline, viz:

date 1 - date 2: place 1

date 2 - date 3: place 2

date 3 - date 4: place 3

etc…

But occasionally a long span, say:

date 4 - date 5: place 4

is interrupted by a shorter span:

date 5 - date 6: place 5

only to be resumed afterwards:

date 6 - date 7: place 4 again.

Would someone kindly point me towards the best soures to look for this kind of functionality, please?

In short, are their functions (in FMP11, 12) that allow me to calculate and store date spans even when they're discontinuous?

Thanks!

I'd use a table of related records with a pair of dates, a location and a calculation field for computing elapsed days in each record. Then the sum of the elapsed days will produce the desired total days regardless of whether or not the date intervals are contiguous.