DATEADD (Report Builder)

Returns a datetime that is the result of adding the specified number of time interval units to the original datetime.

Syntax

DATEADD(interval, units, datetime)

interval	Specifies the units (year, quarter, month, day, hour, minute, second or week) used to calculate the date addition.
units	Specifies the number of intervals.
datetime	Specifies the date to which the intervals are added.

Remarks

Intervals are not case-sensitive.

The following intervals are valid.

Interval	Result
YEAR	Returns a date that is the number of years specified from the datetime.
QUARTER	Returns a date that is the number of quarters specified from the datetime.
MONTH	Returns a date that is the number of months specified from the datetime.
WEEK	Returns a date that is the number of weeks specified from the datetime.
DAY	Returns a date that is the number of days specified from the datetime.
HOUR	Returns a date that is the number of hours specified from the datetime.
MINUTE	Returns a date that is the number of minutes specified from the datetime.
SECOND	Returns a date that is the number of seconds specified from the datetime.

Example

Formula	Result
DATEADD(MONTH, 3, #8/18/2009#)	11/18/2009
DATEADD(DAY, 365, Sell End Date)	Returns a sell end date for each instance that is 365 days from the original sell end date. For example, if the original sell end date is 12/18/2009, the result is 12/18/2010.

See Also

Concepts

Working with Formulas (Report Builder)
Using Functions (Report Builder)
Date and Time Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)

Help and Information

Getting SQL Server 2005 Assistance

Change History

Release	History
12 December 2006	Updated content: Quotation marks are no longer required for intervals.
14 April 2006	New content: Added Remarks section.

Last updated on 2008-12-03