UFN_DATE_THISCALENDARYEAR_FIRSTDAY

Return

Return Type
datetime

Parameters

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

Definition

Copy


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

                set @DATE = dateadd(month, 1 - month(@TODAY), dbo.UFN_DATE_THISMONTH_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