Previous Topic

Next Topic

FirstInYear - SQL Function

FirstInYear(PeriodID: Number[, Financial: Boolean]: Number

Returns the first period in the year that contains PeriodID. If the optional boolean parameter Financial is True then only financial periods are considered (adjustment periods are ignored).

It is also possible to call this function passing a year number in place of PeriodID.

FirstInYear function syntax has these named arguments:

Parameter

Description

Period ID

Required. Period ID to be used to find the first in the year. Can also be passed a Year number.

Financial

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

See Also

SQL Period Functions

Book Contents

Book Index