UFN_DECLARATIONS_AREDATESOVERLAPPING

Returns whether two declarations have overlapping dates.

Return

Return Type
bit

Parameters

Parameter Parameter Type Mode Description
@DECLARATIONONESTARTS datetime IN
@DECLARATIONONEENDS datetime IN
@DECLARATIONTWOSTARTS datetime IN
@DECLARATIONTWOENDS datetime IN

Definition

Copy


            CREATE function dbo.UFN_DECLARATIONS_AREDATESOVERLAPPING
            (
                @DECLARATIONONESTARTS datetime,
                @DECLARATIONONEENDS datetime,
                @DECLARATIONTWOSTARTS datetime,
                @DECLARATIONTWOENDS datetime
            )
            returns bit
            as
            begin
                return dbo.UFN_DATES_AREDATESOVERLAPPING(@DECLARATIONONESTARTS, @DECLARATIONONEENDS, @DECLARATIONTWOSTARTS, @DECLARATIONTWOENDS)
            end