VBScript DateAdd Function
❮ Complete VBScript ReferenceThe DateAdd function returns a date to which a specified time interval has been added.
Syntax
DateAdd(interval,number,date)
Parameter | Description |
---|---|
interval | Required. The interval you want to add Can take the following values:
|
number | Required. The number of interval you want to add. Can either be positive, for dates in the future, or negative, for dates in the past |
date | Required. Variant or literal representing the date to which interval is added |
Examples
Example 1
How to use the parameters:
<%
response.write(DateAdd("yyyy",1,"31-Jan-10") & "<br />")
response.write(DateAdd("q",1,"31-Jan-10") & "<br />")
response.write(DateAdd("m",1,"31-Jan-10") & "<br />")
response.write(DateAdd("y",1,"31-Jan-10") & "<br />")
response.write(DateAdd("d",1,"31-Jan-10") & "<br />")
response.write(DateAdd("w",1,"31-Jan-10") & "<br />")
response.write(DateAdd("ww",1,"31-Jan-10") & "<br />")
response.write(DateAdd("h",1,"31-Jan-10 08:50:00") & "<br />")
response.write(DateAdd("n",1,"31-Jan-10 08:50:00") & "<br />")
response.write(DateAdd("s",1,"31-Jan-10 08:50:00") & "<br />")
%>
The output of the code above will be:
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
Show Example »
Example 2
Subtract one month from January 31, 2010
<%
response.write(DateAdd("m",-1,"31-Jan-10"))
%>
The output of the code above will be:
12/31/2009
Show Example »
Example 3
Add one day from now:
<%
response.write(DateAdd("d",1,Now()))
%>
The output of the code above will be:
6/6/2019 12:03:29 AM
Show Example »
❮ Complete VBScript Reference