﻿alter function dbo.F_DateDiff(@fromDate as int,@toDate as int)       
returns int as    
begin
	declare @str as nvarchar(100);
	IF not EXISTS(SELECT 1 FROM Finance_Cycle_Detail WHERE JDate = @fromDate)
	BEGIN
		set @str = 'تاریخ ' + cast(@fromDate as nvarchar(10)) + ' یافت نشد';
		--RAISERROR(@str,16,1);
		return 0;
	END
	IF not EXISTS(SELECT 1 FROM Finance_Cycle_Detail WHERE JDate = @toDate)
	BEGIN
		set @str = 'تاریخ ' +cast(@toDate as nvarchar(10))+ ' یافت نشد';
		--RAISERROR(@str,16,1);
		return 0;
	END
	declare @from as date;
	declare @to as date;

	SELECT @from=GDate FROM Finance_Cycle_Detail WHERE JDate = @fromDate
	SELECT @to=GDate FROM Finance_Cycle_Detail WHERE JDate = @toDate
	

	declare @res as int = 0;
	set @res = DATEDIFF(DAY, @from, @to)
	return @res;
end

