UFN_DAYOFMONTH_APPLY
Applies day of month to a date
Return
| Return Type |
|---|
| date |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ORIGINALDATE | date | IN | |
| @DAYOFMONTH | smallint | IN |
Definition
Copy
create function dbo.UFN_DAYOFMONTH_APPLY(
@ORIGINALDATE as date
,@DAYOFMONTH as smallint
)
returns date
with execute as caller
as begin
declare @APPLYDATE as date;
if @DAYOFMONTH = 29 -- Last
set @APPLYDATE=dateadd(dd, -day(dateadd(m,1,@ORIGINALDATE)), dateadd(m,1,@ORIGINALDATE));
else
set @APPLYDATE=dateadd(dd,@DAYOFMONTH,dateadd(dd, -day(@ORIGINALDATE),@ORIGINALDATE))
return @APPLYDATE;
end