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) 
FinPerByDate.png

Description: Returns the correct period of 01-01-2014 (the contents of cell D3)

Result: 01-2014

Applies to

  • GL Module

Did this answer your question?