PROJECTSTARTDATE function

Created by Harry Lewis, Modified on Tue, 12 Sep 2023 at 09:33 PM by Damien Zwillinger

Applies to

Velixo NX
Velixo Classic
Acumatica, MYOB Advanced, Cegid

Description

The PROJECTSTARTDATE function returns the start date of a project.

Syntax

PROJECTSTARTDATE(Connection, Project)

Parameters

The PROJECTSTARTDATE 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 Project ID to include

Example

=PROJECTSTARTDATE("Demo", "X")

Description

Returns the start date of the X project.

Result

40544

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.