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