UFN_REVENUE_STARTDATEVALID
Validates that the date of the revenue does not occur after the date passed in.
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @REVENUEID | uniqueidentifier | IN | |
| @STARTDATE | datetime | IN |
Definition
Copy
CREATE function dbo.UFN_REVENUE_STARTDATEVALID
(
@REVENUEID uniqueidentifier,
@STARTDATE datetime
)
returns bit
with execute as caller
as
begin
declare @VALID bit;
declare @REVENUEDATE datetime;
select
@REVENUEDATE = DATE
from
dbo.FINANCIALTRANSACTION
where
FINANCIALTRANSACTION.ID = @REVENUEID;
if dbo.UFN_DATE_GETLATESTTIME(@REVENUEDATE) <= dbo.UFN_DATE_GETLATESTTIME(@STARTDATE)
set @VALID = 1;
else
set @VALID = 0;
return @VALID;
end