UFN_DATE_THISQUARTER_LASTDAY

Return

Return Type
datetime

Parameters

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

Definition

Copy


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

                        set @DATE = DATEADD(dd, -1, DATEADD(qq, DATEDIFF(qq, 0, @TODAY) + 1, 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