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

Did this answer your question?