Description
The FINANCIALPERIODSTARTDATE function returns the Excel date value for the start date of a financial period.
Syntax
FINANCIALPERIODSTARTDATE(Connection, Period)
Parameters
The FINANCIALPERIODSTARTDATE function uses the following parameters (see our articles on including multiple parameter values and using arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | YES | The name of the connection, as specified in the Connection Manager |
Period | YES | The financial period, in MM-YYYY format. |
Example
=FINANCIALPERIODSTARTDATE("Demo", "12-2014")Description: Returns the start date of 12-2014 financial period.
Result: 41974 (The Excel value for December 1, 2014)
Applies to
GL Module