Skip to main content

Returns the period name for the chosen date. Optionally the returned value can be ledger specific and/or a certain number of periods into the future or past.

Parameter Description
Date The date that you want the period name for.
Ledger Optionally enter a Ledger Id to bind the formula to a specific Ledger. If this parameter is omitted, the Ledger currently selected in the Ledger dropdown list will be used.
Offset Optionally enter an offset to return the period name which is n periods before or after the entered criteria e.g. enter 3 to return 3 periods in to the future or enter -1 to return the previous period.

Example:=GLW_Period_Name_By_Date(DATE(2002,1,31),1,5)

Was this article helpful?

We're sorry to hear that.