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 |
Example 1
'Add one month to January 31, 2000
document.write(DateAdd("m",1,"31-Jan-00"))
Output:
2/29/2000
|
Try it yourself »
|
Example 2
'Add one month to January 31, 2001
document.write(DateAdd("m",1,"31-Jan-01"))
Output:
2/28/2001
|
Example
'Subtract one month from January 31, 2001
document.write(DateAdd("m",-1,"31-Jan-01"))
Output:
12/31/2000
|
Try it yourself »
|
Complete VBScript Reference
Need an easy way to get data into XML, or transform XML to another format?
MapForce lets you map XML data to/from any combination of XML, database, flat file, Excel 2007, XBRL, or Web services data.
Then it transforms data instantly or auto-generates royalty-free data integration code for recurrent conversions.
New features in Version 2010!
Download a free, fully functional 30-day trial to experience the following features:
- Easy-to-use, graphical data mapping interface
- Instant data transformation
- XSLT 1.0/2.0 and XQuery code generation
- Java, C#, and C++ code generation
- Advanced data processing functions
- Support for all major relational databases including SQL Server, IBM DB2, Oracle, and more
- Visual Studio & Eclipse integration
Download a fully-functional trial today!
|
|
|
|
