Mute Duck

Get the start of the financial year.

CASE
    WHEN MONTH(GETDATE()) < 7 THEN DATEFROMPARTS(YEAR(GETDATE()) - 1, 7, 1)
    ELSE DATEFROMPARTS(YEAR(GETDATE()) + 0, 7, 1)
END AS [Start_Financial_Year]

Get the end of the financial year.

CASE
    WHEN MONTH(GETDATE()) >= 7 THEN DATEFROMPARTS(YEAR(GETDATE()), 6, 30)
    ELSE DATEFROMPARTS(YEAR(GETDATE()) + 1, 6, 30)
END AS [End_Financial_Year]