UFN_FISCALPERIOD_VALIDSTARTDATE
Validate fiscal period start date
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @STARTDATE | datetime | IN |
Definition
Copy
CREATE function [dbo].[UFN_FISCALPERIOD_VALIDSTARTDATE](@STARTDATE datetime) returns bit
AS
BEGIN
declare @EndDate datetime
declare @Valid bit
Set @Valid = 1
select @EndDate=Max([ENDDATE]) from dbo.GLFISCALPERIOD
where [EndDate] < @STARTDATE
if not @EndDate is null
begin
if @STARTDATE != DateAdd(Day, 1, @EndDate)
Set @Valid = 0
end
Return @Valid
END