Skip to content
  • There are no suggestions because the search field is empty.

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;