UFN_EVENT_VALIDDATESANDTIMES

Validates the event start and end times and dates.
Return

Return Type
bit
Parameters

Parameter	Parameter Type	Mode
@STARTDATE	date	IN
@ENDDATE	date	IN
@STARTTIME	UDT_HOURMINUTE	IN
@ENDTIME	UDT_HOURMINUTE	IN
Definition

Copy


            CREATE function dbo.UFN_EVENT_VALIDDATESANDTIMES
            (
                @STARTDATE date = null,
                @ENDDATE date = null,
                @STARTTIME UDT_HOURMINUTE ='',
                @ENDTIME UDT_HOURMINUTE = ''
            ) 
            returns bit with execute as caller
            as
            begin            

                if @STARTDATE > @ENDDATE begin
                    return 0;
                end;

                if @STARTDATE = @ENDDATE 
                begin
                    if (@STARTTIME is not null) and (@STARTTIME <> '') 
                    begin
                        if (@ENDTIME is null) or (@ENDTIME = '')
                            set @ENDTIME = @STARTTIME                    

                        --if @ENDDATE is null 

                        --    set @ENDDATE = @STARTDATE


                        if @STARTTIME <= @ENDTIME begin
                            return 1
                        end else 
                            return 0                                        
                    end 
                    return 1
                end

                return 1;

                --Only check for invalid times here.  Let the date constraint check for invalid dates.

                --if @STARTDATE < @ENDDATE 

                --    if (@STARTTIME is not null) and (@ENDTIME is not null) 

                --        return 1

                --return 0;

            end