UFN_DATE_LASTQUARTER_FIRSTDAY

Return

Return Type
datetime

Parameters

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

Definition

Copy


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

                        set @DATE = dateadd(month, -3, dbo.UFN_DATE_THISQUARTER_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