title | keywords | f1_keywords | ms.service | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
---|---|---|---|---|---|---|---|---|---|
Application.DateDifference method (Project) |
vbapj.chm131207 |
|
project-server |
|
7f34e866-5cd3-971d-42ee-39e7768c1273 |
06/08/2017 |
medium |
Returns the duration between two dates in minutes, for an automatically scheduled task.
expression. DateDifference
( _StartDate_
, _FinishDate_
, _Calendar_
)
expression A variable that represents an Application object.
Name | Required/Optional | Data type | Description |
---|---|---|---|
StartDate | Required | Variant | The date used as the beginning of the duration. |
FinishDate | Required | Variant | The date used as the end of the duration. |
Calendar | Optional | Object | A resource or task base calendar object. The default value is the calendar of the active project. |
Long
To get a difference between two dates for a manually scheduled task, which uses an effective calendar that can include non-working time, use the EffectiveDateDifference property.
The following example displays the duration of a task that begins on 7/11/97 at 8 A.M. and ends on 7/13/97 at 5:00 P.M.
Sub FindDuration()
MsgBox Application.DateDifference ("7/11/97 8:00 AM", "7/13/97 5:00 PM")
End Sub
[!includeSupport and feedback]