T SQL Script: Get Next Business Day
T SQL Script: Get Next Business Day
CREATE FUNCTION dbo.GetNextBusinessDay(@date date)
RETURNS date
AS
BEGIN
DECLARE @d date = DATEADD(day, 1, @date);
WHILE DATENAME(weekday, @d) IN ('Saturday','Sunday')
SET @d = DATEADD(day, 1, @d);
RETURN @d;
END;
RETURNS date
AS
BEGIN
DECLARE @d date = DATEADD(day, 1, @date);
WHILE DATENAME(weekday, @d) IN ('Saturday','Sunday')
SET @d = DATEADD(day, 1, @d);
RETURN @d;
END;