VBScript DateAdd Function

## VBScript Tutorial

VB HOME VB How to VB Variables VB Procedures VB Conditional VB Looping VB Summary

## VB Examples

VB Examples

## VB References

VB Functions VB Keywords

# 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:

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 code above will be:

Try it yourself »

Complete VBScript Reference

## Your suggestion:

Your E-mail (optional):

Page address:

Description:

Close [X]

## Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

## WEB HOSTING

Best Web Hosting UK Reseller Hosting Wow! $5 SSD Hosting

## WEB BUILDING

Download XML Editor
FREE Website BUILDER FREE Website Creator

## WEB RESOURCES

Web Statistics Web Validation

## SHARE THIS PAGE