通过

Application.DateSubtract Method

  • 项目
Project Developer Reference

Returns the date that precedes another date by a specified duration.

Syntax

expression.DateSubtract(FinishDate, Duration, Calendar)

expression   A variable that represents an Application object.

Parameters

Name Required/Optional Data Type Description
FinishDate Required Variant The date used as the end of the duration.
Duration Required Variant The duration to subtract from the finish date.
Calendar Optional Object A resource, task, or base calendar object. The default value is the calendar of the active project.

Return Value
Variant

Example
The following example displays the start date of a task that lasts three days and ends on 7/13/02 at 5:00 P.M.

Visual Basic for Applications 
  Sub FindDuration()
    MsgBox DateSubtract("7/13/02 5:00 PM", "3d")
End Sub

See Also