How to Create Function For Getting Financial Year From Date.
For Creating Function For Getting Financial Year From Date Copy Below Query and Paste in SQL Server Management Studio and execute.after successful close SQL Server Management Studio and reopen.You will find function under Database→Programmability→Functions. CREATE FUNCTION [dbo].[FinYear] (@input Datetime) returns varchar(20) as begin DECLARE @FinYear VARCHAR(20) select @FinYear=(CASE WHEN (MONTH(@input)) <= 3 THEN CONVERT(VARCHAR(4), YEAR(@input) - 1) + '-' + CONVERT(VARCHAR(4), YEAR(@input) % 100) ELSE CONVERT(VARCHAR(4), YEAR(@input)) + '-' + CONVERT(VARCHAR(4), (YEAR(@input) % 100) + 1) end) RETURN @FinYear end USE ABOVE FUNCTION IN QUERY TYPE SELECT COMMAND AS PER BELOW select dbo.FinYear('01-Apr-2020')