UFN_MEMBERSHIP_CALCULATERENEWALEXPIRATION
Calculates the membership renewal expiration date.
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @EXPIRATIONDATE | datetime | IN | |
| @TERMID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_MEMBERSHIP_CALCULATERENEWALEXPIRATION
(
@EXPIRATIONDATE datetime,
@TERMID uniqueidentifier
)
returns datetime
as
begin
declare @TERMCODE tinyint
select
@TERMCODE = TERMCODE
from dbo.MEMBERSHIPLEVELTERM
where ID = @TERMID;
declare @TERMYEARS tinyint
if @TERMCODE = 6
return null
else
set @TERMYEARS = case when @TERMCODE = 0 then 1
when @TERMCODE = 1 then 2
when @TERMCODE = 2 then 3
when @TERMCODE = 3 then 4
when @TERMCODE = 4 then 5
when @TERMCODE = 5 then 10
else 0 end;
return dateadd(year, @TERMYEARS, @EXPIRATIONDATE)
end