Coding With Fun
Home Docker Django Node.js Articles Python pip guide FAQ Policy

VBScript DateAdd function


May 13, 2021 VBScript


Table of contents


VBScript DateAdd function

The date returned by the VBScript DateAdd function is plus the specified time interval.


VBScript DateAdd function 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 . . .

VBScript DateAdd function Complete VBScript reference manual