Previous Topic

Next Topic

AddPeriod - SQL Function

AddPeriod(PeriodID: Number, Offset: Number, [Financial: Boolean]): Number

Adds Offset to PeriodID. Offset can be either positive or negative.

The optional boolean parameter Financial is True by default, and restricts periods considered to Financial Periods only (excludes Adjustment periods). If specified as False then all periods including Adjustment periods are considered.

AddPeriod function syntax has these named arguments:

Parameter

Description

Period ID

Required. Period ID to be added to.

Offset

Required. Offset to be added to Period ID.

Financial

Optional. If True, only financial periods are considered. If False, all periods including adjustment periods are considered.

Note: To pass boolean parameters to the function use:

cast(1 as boolean) for True.

cast(0 as boolean) for False.

See also the MaxBasic AddPeriod function, and the Web Services AddPeriod function.

See Also

SQL Period Functions

Book Contents

Book Index