SCRS_GetAmountofTime Stored Procedure

  • Article

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