fnSearchDateRangeIsValid
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SearchStartDate | datetime | IN | |
| @SearchEndDate | datetime | IN | |
| @ObjectStartDate | datetime | IN | |
| @ObjectEndDate | datetime | IN |
Definition
Copy
CREATE FUNCTION [dbo].[fnSearchDateRangeIsValid]
(@SearchStartDate datetime, @SearchEndDate datetime, @ObjectStartDate datetime, @ObjectEndDate datetime)
RETURNS bit
AS
BEGIN
DECLARE @DateRangeIsValid bit
SET @DateRangeIsValid = 0
if @SearchStartDate <= @ObjectStartDate and @SearchEndDate >= @ObjectStartDate
SET @DateRangeIsValid = 1
else if @SearchStartDate <= @ObjectEndDate and @SearchEndDate >= @ObjectEndDate
SET @DateRangeIsValid = 1
RETURN @DateRangeIsValid
END