DateAdd function to add date and time

We can add date by using DateAdd function of VBScript using in ASP. We can add any type of value like day, month , year etc using DateAdd function. Here is the syntax for the DateAdd function.

DateAdd ( date_type, increment_by, date)

Here date_type is the type of date to be added. It can be month, year, Day, Hour, minute etc. Different values are available in a table at the end of this tutorial. The argument increment_by is the interval we want to add to the third argument date.

Here is the code explaining the use of DateAdd function.

Dim d_today,d_added
d_today=Date
Response.Write "Today date is " & d_today & "<br>"
d_added=DateAdd("yyyy",5,d_today)
Response.Write "Add 5 Years " & d_added & "<br>"

In the above code we have added five years to the current date. By changing the value of date_type we can add month, days etc to the present date. Here is the code to add 6 months to today.

d_added=DateAdd("m",6,d_today)

DateAdd function will not return any invalid date. Let us try with this example.

d_added=DateAdd("d",32,#1/28/04#)

This line will return 2/29/2004,

Now let us change the year to 2003 and see the result

d_added=DateAdd("d",32,#1/28/03#)

The output of above line is 3/1/2003
This way we can add different types of dates to an existing date & time.
Table for different date_type values
ValueMeaning
"yyyy"Year
"m"Month
"d"Day
"h"Hour
"n"Minute
"s"Second
"w"Weekday
"ww"Week of the year
"q"Quarter

Be the first to post comment on this article :





Post your comments , suggestion , error , requirements etc here .




We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2019 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer