USE [DB]
GO
/****** Object: UserDefinedFunction [dbo].[udf_Fiscal_Year] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Description: <Description,,>
-- =============================================
ALTER FUNCTION [dbo].[udf_Fiscal_Year] (@datetime datetime)
RETURNS varchar(50)
AS
begin
declare @FY varchar(50)
select @FY=(CASE WHEN Month(@datetime) IN (5,6,7,8,9,10,11,12) THEN Year(Dateadd(yy,1,@datetime)) ELSE Year(@datetime) END)
return @FY
end
No comments:
Post a Comment