UFN_SPONSORSHIPPASTDUEREPORT_GETMONTHS
Returns number of months past due based on current date.
Return
| Return Type |
|---|
| int |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN |
Definition
Copy
CREATE function dbo.UFN_SPONSORSHIPPASTDUEREPORT_GETMONTHS(
@REVENUEID uniqueidentifier
)
returns int
as begin
declare @NEXTTRANSACTIONDATE datetime
declare @MONTHS int = 0
select @NEXTTRANSACTIONDATE = min(DATE)
from dbo.UFN_RECURRINGGIFTINSTALLMENT_GETWRITEOFFINSTALLMENTS(@REVENUEID)
where DATE < GETDATE()
set @MONTHS = datediff(month, @NEXTTRANSACTIONDATE, getdate())
return @MONTHS
end