SetPeriod

Syntax

SetPeriod(StartDate: Variant, EndDate: Variant)

Parameters

StartDate. Period start date.

EndDate. Period end date.

Description

It creates period by specified data.

Comments

For the method correct work, period start date should be less than period end date.

SetPeriod can be used to set up calculation period in arithmetic methods where data array is the input parameter. To set calculation period, determine SetPeriod in any array place, for example:

Average({Albania|BCA[t]}, SetPeriod(2000,2010))

The mean value of the {Albania|BCA[t]} series will be found for the period from 2000 to 2010.

The date can be specified in one of the following formats:

Format	Description
"01.01.2000"	Specify a certain date in the year.
2000 or "2000A"	The beginning of the year is used as date.
"2000S1"	The beginning of the specified half-year is used as date.
"2000-H1"	The date corresponding to 9 months of the year is used as date.
"2000Q1"	The beginning of the specified quarter is used as date.
"2000M1"	The beginning of the specified month is used as date.
"2000-W1"	The beginning of the specified week is used as date.

Example

The function use is given in the example for the Median function.