CREATE FUNCTION dbo.DaysToComplete (@CloseDate Date, @OpenDate Date) RETURNS INT AS BEGIN DECLARE @DayDiff int = DATEDIFF(D, @OpenDate, @CloseDate) if @DayDiff < 0 set @DayDiff = 0 return @DayDiff endHere are 2 tests...
select dbo.DaysToComplete( '5/1/2014', '5/15/2014') returns zero select dbo.DaysToComplete( '5/15/2014', '5/1/2014') returns 14