Previous Topic

Next Topic

Book Contents

Book Index

SQL Period Functions

Function

Description

AddPeriod

Adds periods to a PeriodID.

CurrentPeriod

Returns the Current Period for a module.

DateWithinPeriod

Returns True if a Date is in the valid range for a Period.

FirstAvailablePeriod

Returns the first available period for a module.

FirstInYear

Returns the first period in the year the contains a PeriodID, or the first period for a year.

FirstPeriod

Returns the first period in the Company.

FirstUserPeriod

Returns the first period which the User may post transactions into for a specified module.

LastAvailablePeriod

Returns the last available period for a module.

LastInYear

Returns the last period in the year the contains a PeriodID, or the last period for a year.

LastPeriod

Returns the last period in the Company.

LastUserPeriod

Returns the last period which the User may post transactions into for a specified module.

MakePeriodID

Creates a period ID.

PeriodEndDate

End date for a period.

PeriodForDate

Returns the period ID of the period containing a date.

PeriodName

Returns the name of a period.

PeriodPeriodNo

Return the period number of a period.

PeriodStartDate

Start date for a period.

PeriodYearNo

Returns year of a period.

SystemPeriod

Returns current System Period ID.

YearName

Returns year name for a period.

In This Section

AddPeriod - SQL Function

CurrentPeriod - SQL Function

DateWithinPeriod - SQL Function

FirstAvailablePeriod - SQL Function

FirstInYear - SQL Function

FirstPeriod - SQL Function

FirstUserPeriod - SQL Function

LastAvailablePeriod - SQL Function

LastInYear - SQL Function

LastPeriod - SQL Function

LastUserPeriod - SQL Function

MakePeriodID - SQL Function

PeriodEndDate - SQL Function

PeriodForDate - SQL Function

PeriodName - SQL Function

PeriodPeriodNo - SQL Function

PeriodStartDate - SQL Function

PeriodYearNo - SQL Function

SystemPeriod - SQL Function

YearName - SQL Function