UFN_DATE_NEXTWEEK_FIRSTDAY

Return

Return Type
datetime

Parameters

Parameter Parameter Type Mode Description
@TODAY datetime IN
@USELATESTTIME bit IN

Definition

Copy


        create function dbo.UFN_DATE_NEXTWEEK_FIRSTDAY(@TODAY datetime, @USELATESTTIME bit)
            returns datetime
            with execute as caller
            as
            begin
                declare @DATE datetime

                set @DATE = dateadd(day, 7, dbo.UFN_DATE_THISWEEK_FIRSTDAY(@TODAY, 0))

                if @USELATESTTIME = 0
                begin
                    set @DATE = dbo.UFN_DATE_GETEARLIESTTIME(@DATE)
                end
                else
                begin
                    set @DATE = dbo.UFN_DATE_GETLATESTTIME(@DATE)
                end

                return @DATE
            end