Description
The FINANCIALPERIODBYDATE function returns the correct period of a given date.
Syntax
FINANCIALPERIODBYDATE(Connection, Date)
Parameters
The FINANCIALPERDIODBYDATE function uses the following parameters (see our article on using arrays or cell ranges as parameters):
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection, as specified in the Connection Manager |
Date | Required | A cell reference containing the the date or An Excel DATE() function |
Example
=FINANCIALPERIODBYDATE("Demo", D3) 
Description: Returns the correct period of 01-01-2014 (the contents of cell D3)
Result: 01-2014
Applies to
GL Module