FINANCIALPERIODBYDATE function
Modified on Fri, 15 Sep 2023 at 04:49 PM
Applies to:
GL Module
ERP: Acumatica, CEGIC, Haufe x360, JAMIS Prime, MYOB Advanced
Description
The FINANCIALPERIODBYDATE function returns the correct period of a given date (as defined in the ERP's master financial calendar).
TABLE OF CONTENTS
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
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article