T SQL Script: GetFinancialYear-(UK‑style)
T SQL Script: GetFinancialYear-(UK‑style)
REATE FUNCTION dbo.GetFinancialYear(@d date)
RETURNS varchar(9)
AS
BEGIN
DECLARE @y int = YEAR(@d);
IF MONTH(@d) < 4 SET @y = @y - 1;
RETURN CONCAT(@y, '/', @y + 1);
END;
RETURNS varchar(9)
AS
BEGIN
DECLARE @y int = YEAR(@d);
IF MONTH(@d) < 4 SET @y = @y - 1;
RETURN CONCAT(@y, '/', @y + 1);
END;