UFN_SCHEDULEDATEADJUSTMENT_DATEVALID

Check to see if the date is valid for the given session

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@DATE	date	IN
@SCHOOLID	uniqueidentifier	IN

Definition

Copy



            create function dbo.UFN_SCHEDULEDATEADJUSTMENT_DATEVALID
            (
              @DATE date,
              @SCHOOLID uniqueidentifier
            )
            returns BIT
            as 
            begin
                declare @DATEVALID bit = 0
                declare @TERMID uniqueidentifier
                set @TERMID = dbo.UFN_SCHEDULEDATE_GETTERM (@DATE, @SCHOOLID)

                if (not @TERMID is NULL) and (not @DATE = (select STARTDATE from TERM where ID = @TERMID)) and (dbo.UFN_SCHEDULEDATE_INSESSION_VALID(@DATE, @SCHOOLID) = 1)
                    set @DATEVALID = 1
                else
                    set @DATEVALID = 0

                return @DATEVALID
            end