UFN_SCHEDULE_DATEVALID2

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@DT	datetime	IN
@START	date	IN
@END	date	IN

Definition

Copy



            create function dbo.UFN_SCHEDULE_DATEVALID2(@DT datetime, @START date, @END date) returns bit with execute as caller
            as
            begin
                if @DT between @START and @END
                    return 1;

                return 0;
            end