VBScript DateAdd Function
 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
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 »
|
Example 3
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:
Try it yourself »
|
Complete VBScript Reference
Whether you're new to XML or already an advanced user,
the user-friendly views and powerful entry helpers,
wizards, and debuggers in XMLSpy are designed to meet your XML
and Web development needs from start to finish.
New features in Version 2010!
- XML editor
- Graphical XML Schema / DTD editors
- XSLT 1.0/2.0 editor, debugger, profiler
- XQuery editor, debugger, profiler
- XBRL validator, taxonomy editor, taxonomy wizard
- Support for Office Open XML (OOXML)
- Graphical WSDL 1.1/2.0 editor & SOAP debugger
- JSON editing & conversion
- Java, C#, C++ code generation
- And much more!
Download a free trial today!
|
|
|
|
