VBScript DateAddFunction

VBScript 参考手册Complete VBScript Reference

The DateAdd function returns a date to which a specified time interval has been added.

Syntax

DateAdd(interval,number,date)

Parameters Description
interval Required. The time interval you want to add.

The following values can be used:

  • yyyy - Year
  • q - Quarter
  • m - Month
  • y - Day of year
  • d - Day
  • w - Day of week
  • ww - Week of year
  • h - Hour
  • n - Minute
  • s - Second
number Required. The number of time intervals to add. Use positive values for future dates and negative values for past dates.
date Required. A variable or literal representing the date to which the time 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 example above:

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, 2001:

<script type="text/vbscript">

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

</script>

The output of the example above:

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 example above:

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

Try it Yourself »
VBScript 参考手册Complete VBScript Reference Other Extensions