VBScript in a Nutshell

Name

DateAdd Function

Syntax

DateAdd(interval, number, date)

interval

Use: Required

Data Subtype: String

An expression denoting the interval of time you need to add or subtract (see the following table “Interval Settings”).

number

Use: Required

Data Subtype: Numeric expression

An expression denoting the number of time intervals you want to add or subtract.

date

Use: Required

Data Subtype: Date

A Variant of subtype Date or a literal denoting the date on which to base the DateAdd calculation.

Interval Settings

Setting	Description
yyyy	Year
q	Quarter
m	Month
y	Day of year
d	Day
w	Weekday
ww	Week
h	Hour
n	Minute
s	Second

Return Value

A Variant of subtype Date.

Description

Returns a variant of subtype Date representing the result of adding or subtracting a given number of time periods to or from a given date or time. For instance, you can calculate the date 178 months before today’s date, or the date and time 12,789 minutes from now.

Rules at a Glance

• Specify the interval value as a string enclosed in quotation marks (e.g., "ww").

• If number is positive, the result will be after date; if number is negative, the result will be before date.

• The DateAdd function has a built-in calendar algorithm to prevent it from returning an invalid date. For example, you can add 10 minutes to 31 December 1999 23:55, and DateAdd automatically recalculates all elements of the date to return a valid date, in this case, 1 January 2000 00:05. This includes leap years: the calendar ...