All Functions
CDate Function
Date Function
DateAdd Function
DateDiff Function
DatePart Function
DateSerial Function
DateValue Function
Now Function
Time Function
FUNCTION: DateAdd( )
Implemented in version 2.0
DateAdd
(Interval, Number, Date)
The
DateAdd
function adds a time interval to any date.
There are three mandatory arguments.
Interval
The
Interval
argument defines the the type of time interval you wish to add onto the date.
You must place the setting inside double quotes.
Only the following settings may be used.
SETTING
DESCRIPTION
YYYY
Year
Q
Quarter
M
Month
Y
Day Of Year
D
Day
W
WeekDay
WW
Week Of Year
H
Hour
N
Minute
S
Second
Number
The
Number
argument is a multiplier for the Interval argument (i.e., how many days, weeks, months, etc.). If this is a positive number, you will go forward in time. A negative number will go back in time.
Date
The
Date
argument is a date or time.
If you wish to use the current date or time, simply use the
Date
or the
Now
functions.
Code:
<% =Date %>
<% =DateAdd("WW", 6, Date) %>
Output:
3/16/99
4/27/99
Code:
<% =Now %>
<% =DateAdd("S", 30, Now) %>
Output:
3/16/99 12:14:00 PM
3/16/99 12:14:30 PM
Code:
<% ="1/1/2001" %>
<% =DateAdd("YYYY", 1000, "1/1/2001") %>
Output:
1/1/2001
1/1/3001
Copyright 1999-2004 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information