DateAdd function Date used in ASP

DateAdd function usage in ASP

2006/09/22 12:29

Note that the VBS and SQL are slightly different, and the following posts are for the VBS help.

SQL searchable SQL self-help document

A string expression that represents the time interval to add. For numeric values, see the "Settings" section.

Returns the date that the specified time interval has been added.

DATEADD (interval, number, date)

Parameters

Interval

Required option.

Number

Required option. Numeric expression that represents the number of time intervals to add. Numeric expressions can be positive (get future dates) or negative numbers (get past dates).

Date

Required option. Variant or text to be added to the interval representation date.

Set up

The interval parameter can have the following values:

Table

Description

You can add or subtract a specified time interval from a date by using the DATEADD function. For example, you can use DATEADD to calculate the date 30 days from today or 45 minutes from now. To add a time interval of "Day" to date, you can use the number of days per year (y), day (d), or number of days of the Week (W).

The DATEADD function does not return an invalid date. The following example adds one months to January 31, 95:

Newdate = DateAdd ("M", 1, "31-jan-95") in this example, DATEADD returns February 28, 95 instead of February 31, 95. If date is January 31, 96, it returns February 29, 96, because 1996 is a leap year.

If the calculated date is before 100 A.D., an error is generated.

If number is not a Long value, it is rounded to the nearest integer before being evaluated.