PROJECTENDDATE function
Created by Harry Lewis, Modified on Thu, 05 Oct 2023 at 05:50 PM by Gabriel Michaud
Applies to
- Velixo NX
- Velixo Classic
- Acumatica, MYOB Advanced, Cegid
Description
The PROJECTENDDATE function returns the end date of a project.
Syntax
PROJECTENDDATE(Connection, Project)
Parameters
The PROJECTENDDATE function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Project | Optional | The Project ID to include |
Example
=PROJECTENDDATE("Demo", "01SUPPORT")Description
Returns the end date of the 01SUPPORT project.
Result
41670
Note that the results are returned as a serial number - to match Excel's default treatment for dates. The cell can be formatted to any date format desired. |
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