UFN_DATE_THISWEEK_LASTDAY

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

                set @DATE = dateadd(day, 7 - datepart(weekday, @TODAY), @TODAY)

                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