Previous Topic

Next Topic

LastPeriod - SQL Function

LastPeriod[(Financial: Boolean)]: Number

Returns the last period in the Company. If the optional boolean parameter Financial is True then only financial periods are considered (adjustment periods are ignored).

LastPeriod function syntax has these named arguments:

Parameter

Description

Financial

Optional. If True, only financial periods are considered. If False, all 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

SQL Period Functions

Book Contents

Book Index