AX2363

GetPeriod function

Returns the current period for the system or for a specified table.

Syntax

GetPeriod("PeriodSource", "TableName")

Parameter Description

PeriodSource

Parameter	Description
PeriodSource	Specify which current period you want to return: `System`: Returns the current period for the system, as defined in Administration > Tables > Table Management > System Current Period / Year. `Table`: Returns the current period for the specified table, as defined for the table in Administration > Tables > Table Management > Table Current Periods. `SystemYear`: Returns the current year for the system, as defined in Administration > Tables > Table Management > System Current Period / Year.
TableName	If the PeriodSource is `Table`, specify the table name.

Specify which current period you want to return:

System: Returns the current period for the system, as defined in Administration > Tables > Table Management > System Current Period / Year.
Table: Returns the current period for the specified table, as defined for the table in Administration > Tables > Table Management > Table Current Periods.
SystemYear: Returns the current year for the system, as defined in Administration > Tables > Table Management > System Current Period / Year.

TableName If the PeriodSource is Table, specify the table name.

All non-numeric entries must be placed in double quotation marks, unless you are using cell references to reference the text held in another cell.

Remarks

GetPeriod is a non-volatile function.

Examples

=GetPeriod("System")

This example returns the system current period; for example: 6.

=GetPeriod("Table","Pay2021")

This example returns the current period for the Pay2021 table; for example: 20.

=GetPeriod("SystemYear")

This example returns the system current year; for example: 2021.