VBScript
DateAdd
function
The date returned by the VBScript DateAdd function is plus the specified time interval.
Complete VBScript reference manual
The DateAdd function returns the date on which the specified interval has been added.
Grammar
DateAdd(interval,number,date)
Parameters
parameter
|
describe
|
interval
|
Required.The time interval you want to add.
The following value can be used:
-
YYYY - year
-
Q - quarter
-
M - month
-
Y - the first day of the year
-
D - day
-
W - as the first few days
-
WW - the last year
-
H - hour
-
n - points
-
s - second
|
number
|
Required.Need to add the number of time intervals.You can use a positive value for future dates to use negative values for past dates.
|
date
|
Required.A variable or text representative of the date that is added.
|
Instance 1
How to use parameters:
<script type="text/vbscript">
document.write(DateAdd("yyyy",1,"31-Jan-10") & "<br />")
document.write(DateAdd("q",1,"31-Jan-10") & "<br />")
document.write(DateAdd("m",1,"31-Jan-10") & "<br />")
document.write(DateAdd("y",1,"31-Jan-10") & "<br />")
document.write(DateAdd("d",1,"31-Jan-10") & "<br />")
document.write(DateAdd("w",1,"31-Jan-10") & "<br />")
document.write(DateAdd("ww",1,"31-Jan-10") & "<br />")
document.write(DateAdd("h",1,"31-Jan-10 08:50:00") & "<br />")
document.write(DateAdd("n",1,"31-Jan-10 08:50:00") & "<br />")
document.write(DateAdd("s",1,"31-Jan-10 08:50:00") & "<br />")
</script>
The above example output results:
1/31/2011
4/30/2010
2/28/2010
2/1/2010
2/1/2010
2/1/2010
2/7/2010
1/31/2010 9:50:00 AM
1/31/2010 8:51:00 AM
1/31/2010 8:50:01 AM
Try it out . . .
Instance 2
Subtract one month from January 31, 2001:
<script type="text/vbscript">
document.write(DateAdd("m",-1,"31-Jan-10"))
</script>
The above example output results:
12/31/2009
Try it out . . .
Instance 3
Add a day from now:
<script type="text/vbscript">
document.write(DateAdd("d",1,Now()))
</script>
The above example output results:
document.write(DateAdd("d",1,Now()))
Try it out . . .
Complete VBScript reference manual