In SCRM 2006, SCRS_GetAmountofTime gets weekly representation of a time span calculated in days.
SCRS_GetAmountofTime @LocaleID
,@StartDate
,@EndDate
Arguments
@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.
Return Code
Type: int
Value: Always 0.
Results Sets
| Column name | Data Type | Description |
|---|---|---|
Weeks |
Int32 |
Datediff in Weeks. |
Days |
Int32 |
Datediff in Days. |
See Also
Other Resources
Sample SCRM Stored Procedures
SCRM 2006 Report Customization
SCRM 2006 SQL Views
SCRM 2006 Stored Procedures