Get 1st-July-Previous year in MS SQL Server

4

If you need a date data type: datefromparts(year(getdate()) - iif(month(getdate()) < 7, 1, 0), 7, 1)
If you need a datetime data type: datetimefromparts(year(getdate()) - iif(month(getdate()) < 7, 1, 0), 7, 1, 0, 0, 0, 0)