StartDriver.EffectiveDateDifference property (Project)
Gets the duration between two dates in minutes, using the effective calendar for a manually scheduled task. Read-only Long.
Syntax
expression. EffectiveDateDifference( _StartDate_, _FinishDate_ )
expression An expression that returns a StartDriver object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| StartDate | Required | Variant | Arbitrary start date and time, for example, "7/10/2010" or "7/10/2010 2:00:00 PM". |
| FinishDate | Required | Variant | Arbitrary finish date and time. |
Remarks
The EffectiveDateDifference property uses the effective calendar for manually scheduled tasks, which allows tasks to start and finish on non-working times. The StartDate and FinishDate arguments can be arbitrary dates. The property and arguments don't affect the task dates.
Use the EffectiveDateSubtract, EffectiveDateAdd, and EffectiveDateDifference properties to calculate start and finish dates for manually scheduled tasks.
To calculate the date difference for an automatically scheduled task, where you can also specify the calendar, use the DateDifference method.
Example
The following statement returns the value 480, which shows that the finish date is 8 hours of working time after the start date.
Debug.Print ActiveProject.Tasks(3).StartDriver.EffectiveDateDifference("7/1/2009 3:00:00 PM", "7/2/2009 3:00:00 PM")
The following statement returns the value -840, which shows that the finish date is 14 hours of working time before the start date.
Debug.Print ActiveProject.Tasks(3).StartDriver.EffectiveDateDifference("7/1/2009 3:00:00 PM", "6/30/2009 8:00:00 AM")
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.