Applies to
⚠️ Velixo NX only
ERP: Sage Intacct
This function applies to Sage Intacct connections only. For Acumatica/MYOB/CEGID/JAMIS Prime, see PROJECTENDDATE
Description
The SI.PROJECTENDDATE function returns the ending date for the specified project (in culture-neutral date format).
Syntax
SI.PROJECTENDDATE(Connection, Project)
The SI. PROJECTENDDATE function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Project | Required | The ID for the project for which the end date is to be retrieved. |
Examples
Example #1
=SI.PROJECTENDDATE("Sage", "10000")
Description
Returns the ending date for project 10000.
Results
Example #2
=SI.PROJECTENDDATE("Sage", C1#)
Description
Returns the ending date for each project displayed by the array function in cell C1.
Results
Example #3
=SI.PROJECTENDDATE("Sage", C1:C20)
Description
Returns the ending date for each project displayed in cells C1 through C20.
Results
