UFN_DATE_LASTQUARTER_LASTDAY
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @TODAY | datetime | IN | |
| @USELATESTTIME | bit | IN |
Definition
Copy
create function dbo.UFN_DATE_LASTQUARTER_LASTDAY(@TODAY datetime, @USELATESTTIME bit)
returns datetime
with execute as caller
as
begin
declare @DATE datetime
set @DATE = dateadd(day, -1, 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