Search w3schools.com:

SHARE THIS PAGE

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:

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

Try it yourself »

Example 2

Subtract one month from January 31, 2010

<script type="text/vbscript">

document.write(DateAdd("m",-1,"31-Jan-10"))

</script>

The output of the code above will be:

12/31/2009

Try it yourself »

Example 3

Add one day from now:

<script type="text/vbscript">

document.write(DateAdd("d",1,Now()))

</script>

The output of the code above will be:


Try it yourself »
VBScript Reference Complete VBScript Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]