Skip to content
  • There are no suggestions because the search field is empty.

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;