UFN_GLFISCALYEAR_COPYSTARTDATE
Used for Fiscal Year copy operation. Determines correct start date handling leap years.
Return
| Return Type |
|---|
| datetime |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STARTDATE | datetime | IN | |
| @YEARDIFFERENCE | int | IN |
Definition
Copy
create function dbo.UFN_GLFISCALYEAR_COPYSTARTDATE(@STARTDATE datetime, @YEARDIFFERENCE int)
returns datetime
as
begin
declare @RETURNDATE datetime
set @RETURNDATE = dateadd(year, @YEARDIFFERENCE, @STARTDATE)
--If the original StartDate is 2/29, it should be set to 3/1
if (month(@STARTDATE) = 2) and (day(@STARTDATE) = 29) and (@YEARDIFFERENCE % 4 <> 0)
set @RETURNDATE = dateadd(day, 1, @RETURNDATE) -- Add a day since T-SQL has set the date to 2/28
return @RETURNDATE
end