Name
DateAdd Function
Class
Microsoft.VisualBasic.DateAndTime
Syntax
DateAdd(interval
,number
,datevalue
)
-
interval
(required; String orDateInterval
enum) A 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
(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) 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 |
---|---|
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 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” and “past” here is relative todatevalue
.)The DateAdd function ...
Get VB.NET Language in a Nutshell, Second Edition 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.