THE WORLD'S LARGEST WEB DEVELOPER SITE
HTMLCSSJAVASCRIPTSQLPHPBOOTSTRAPJQUERYANGULARXML
 

VBScript DateAdd Function


VBScript Reference Complete VBScript Reference

The 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:

  • 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 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:

5/12/2016 5:49:46 AM
Show Example »

VBScript Reference Complete VBScript Reference