This documentation is archived and is not being maintained.
SCRS_GetAmountofTime Stored Procedure
In SCRM 2006, SCRS_GetAmountofTime gets weekly representation of a time span calculated in days.
SCRS_GetAmountofTime @LocaleID
,@StartDate
,@EndDate
@LocaleID
Type: int
Locale identifier for the installed product.
@StartDate
Type: datetime
Value for lower bound of date range for conversion to integer representation of weeks.
@EndDate
Type: datetime
Value for upper bound of date range for conversion to integer representation of weeks.
Type: int
Value: Always 0.
|
Column name
|
Data Type
|
Description
|
| Weeks | Int32 | Datediff in Weeks. |
| Days | Int32 | Datediff in Days. |