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

 

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

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article