SI.PERIODENDDATE

Created by Damien Zwillinger, Modified on Thu, 5 Oct, 2023 at 9:25 PM by Damien Zwillinger

Applies to:

  • Velixo NX
  • Sage Intacct


The SI.PERIODENDDATE function returns the start date of the specified reporting period.

 

Syntax

SI.PERIODENDDATE(Connection, ReportingPeriodName)

 

The SI. PERIODENDDATE function uses the following parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

ReportingPeriodName

Optional

The name of the reporting period(s) for which we want to determine the ending date

Examples

 

Example #1 

SI.PERIODENDDATE("Sage", A2)

 

Description

Returns the ending date for the reporting period listed in cell A2

 

Results

 

 


Example #2

SI.PERIODENDDATE("Sage", A2#)

 

Description

Returns the ending date for each of the reporting periods listed by the array function in cell A2.

 

Results

 

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 at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article