VB.NET Language Pocket Reference

Name

DateAdd Function — Microsoft.VisualBasic.DateAndTime

Synopsis

DateAdd(interval, number, datevalue)

interval required; String or DateInterval enum

The interval of time to add

number required; Double

An expression denoting the number of time intervals you want to add (it can be positive or negative)

datevalue required; Date, or an expression capable of conversion to a date

The starting date to which the interval is to be added

Return Value

A past or future Date that reflects the result of the addition

Description

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

interval can be one of the following literal strings:

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

interval can also be a member of the DateInterval enum:

Enum DateInterval
   Day
   DayOfYear
   Hour
   Minute
   Month
   Quarter
   Second
   Week
   Weekday
   WeekOfYear
End Enum

If number is positive, the result will be in the future; if number is negative, the result will be in the past. (The meaning of “future” and “past” here is relative to datevalue.)

The DateAdd function has a built-in calendar algorithm to prevent it from returning an invalid date. You can add 10 minutes to 31 December 1999 23:55, and DateAdd automatically recalculates all elements of the date to return a valid ...