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
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 »
|
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 »
|
Complete VBScript Reference
Stylus Studio® 2010 XML Enterprise Suite raises the bar for productivity in XML development tools.
Millions of XML developers and data integration specialists turn to Stylus Studio's comprehensive and intuitive
XML toolset to tackle today's advanced XML data transformation and aggregation challenges.
|
- XML Pipeline Editor, Debugger and Code Generator
- DataDirect XML Converters
- XQuery Mapper, Editor, Debugger, and Profiler
- XSLT Mapper, Editor, Debugger, Designer, and Profiler
- Java and C# for .Net Code Generation
- XML Schema Designer With Documentation Generator
- XML Editor With Full XPath Integration
Download a free trial now
|
|
