UFN_DATE_THISQUARTER_FIRSTDAY

Return

Return Type
datetime

Parameters

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

Definition

Copy


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

                        set @DATE = DATEADD(qq, DATEDIFF(qq, 0, @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