SCRS_GetAmountofTime Stored Procedure

System Center

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.

Show: