StartDriver.EffectiveDateSubtract property (Project)

Gets the date and time that precedes another date by a specified duration, using the effective calendar for a manually scheduled task. Read-only Variant.

Syntax

expression. EffectiveDateSubtract( _Date_, _Duration_ )

expression An expression that returns a StartDriver object.

Parameters

Name Required/Optional Data type Description
Date Required Variant Arbitrary date and time, for example, "7/10/2010" or "7/10/2010 2:00:00 PM".
Duration Required Variant Duration to subtract, for example, "3d" or "2w".

Remarks

The EffectiveDateSubtract property uses the effective calendar for manually scheduled tasks, which allows tasks to start and finish on non-working times. The property and arguments have no effect on actual task dates.

Use the EffectiveDateSubtract, EffectiveDateAdd, and EffectiveDateDifference properties to calculate start and finish dates for manually scheduled tasks.

To calculate a date for an automatically scheduled task, where you can also specify the calendar, use the DateSubtract method.

Example

The following statement returns the value "6/24/2009 8:00:00 AM", which is six days before the specified date.

Debug.Print ActiveProject.Tasks(3).StartDriver.EffectiveDateSubtract("7/2/2009", "6d")

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.