Duration of Subscription within Floating 12-month Period

This component calculates the duration of any event/subscription (with Activation and Expiration dates' information provided) in frames of a floating 12-month period. This is useful for yearly reports, when one needs, for instance, to calculate the duration of the active subscription falling into the reporting period.

The user can specify the beginning date of the 12-month period and the component will automatically determine the end of the period (+12 month) and calculate the duration of each contract/event/subscription which was active in this selected period, considering also the point in time of activation and expiration dates.

Before calculating, the input data table is filtered and the following cases are removed:
- when both activation&expiration dates lay before the start date or after the end date of the 12-month period;
- when activation date starts after the expiration date.

Input ports

1. Type: Table
   Subscription Data
   Data Table containing information of start and end (activation and expiration) dates (Local Date format) of some event/subscription/contract, which duration you want to calculate.

Output ports

1. Type: Table
   Subscription Data with Calculated Duration
   Input Data Table with appended calculated duration.