Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the difference between the Start datetime and the End datetime.
Syntax
DATEDIFF(interval, datetime, datetime)
interval |
Specifies the units (year, quarter, month, day, hour, minute, second or week) used to calculate the date difference. |
datetime |
Specifies the start date. |
datetime |
Specifies the end date. |
Remarks
- Intervals are not case-sensitive.
The following intervals are valid.
| Interval | Results |
|---|---|
YEAR |
Returns the number of years between the start and end date values. |
QUARTER |
Returns the number of quarters between the start and end date values. |
MONTH |
Returns the number of months between the start and end date values. |
WEEK |
Returns the number of weeks between the start and end date values. |
DAY |
Returns the number of days between the start and end date values. |
HOUR |
Returns the number of hours between the start and end date values. |
MINUTE |
Returns the number of minutes between the start and end date values. |
SECOND |
Returns the number of seconds between the start and end date values. |
Example
| Formula | Result |
|---|---|
DATEDIFF(MONTH, #1/1/2009#, #3/31/2009#) |
2 |
DATEDIFF(DAY, Sell Start Date, Sell End Date) |
Returns the number of days difference for each instance of the Sell Start Date and Sell End Date fields. |
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 |
|
14 April 2006 |
|