PROJECTTASKSTARTDATE

Overview

The PROJECTTASKSTARTDATE function returns the start date of a project task.

CODE

=PROJECTTASKSTARTDATE(Connection, Project, ProjectTask)

The PROJECTTASKSTARTDATE function uses the following arguments (see our article on filtering Velixo functions):

Argument	Required/Optional	Description
`Connection`	Required	The name of the connection as configured in the Connection Manager
`Project`	Required	The Project(s) to include
`ProjectTask`	Required	The ID(s) of the Task(s) to include

CODE

=PROJECTTASKSTARTDATE("Demo","FIXEDP01", "01TASK")

Description

Returns the start date of 01TASK task of the FIXEDP01 project.

Result

41456

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.

Applies to:

PM Module