Name
DateAdd Function
Class
Microsoft.VisualBasic.DateAndTime
Syntax
DateAdd(interval, number, datevalue
)
-
interval
Use: Required
Data Type: String or
DateInterval
enumA String expression (see the first item in Section ) or a member of the
DateInterval
enumeration (see the second item in Section ) that specifies the interval of time to add.-
number
Use: Required
Data Type: Double
An expression denoting the number of time intervals you want to add (it can be positive or negative
-
datevalue
Use: Required
Data Type: Date, or an expression capable of conversion to a date
Date representing 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.
Rules at a Glance
interval
can be one of the following literal strings:
String |
Description |
---|---|
|
Year |
|
Quarter |
|
Month |
|
Day of year |
|
Day |
|
Weekday |
|
Week |
|
Hour |
|
Minute |
|
Second |
interval
can also be a member of theDateInterval
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; ifnumber
is negative, the result will be in the past. (The meaning of “future” ...
Get VB .NET Language in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.