UFN_SCHEDULEDATE_DATEVALID
Check to see if the date is valid for the given school
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @DATE | date | IN | |
| @SCHOOLID | uniqueidentifier | IN |
Definition
Copy
create function dbo.UFN_SCHEDULEDATE_DATEVALID
(
@DATE date,
@SCHOOLID uniqueidentifier
)
returns BIT
as
begin
declare @DATEVALID bit = 0
if not dbo.UFN_SCHEDULEDATE_GETTERM (@DATE, @SCHOOLID) is NULL
set @DATEVALID = 1
else
set @DATEVALID = 0
return @DATEVALID
end