UFN_DATE_THISCALENDARYEAR_LASTDAY

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

                set @DATE = dateadd(year, 1, dateadd(month, 1 - month(@TODAY), dbo.UFN_DATE_THISMONTH_FIRSTDAY(@TODAY, 0))) - 1

                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