-- select FORMAT(DATEFROMPARTS(YEAR(getdate())+1, MONTH(getdate())-11, 1), 'yyyy-MM-dd');


-- select YEAR(getdate())+1; -- 2024

-- select MONTH(getdate())-11; --   -1

-- SELECT DATEFROMPARTS(2018, 10, 31) AS DateFromParts;

  -- SELECT DATEFROMPARTS(YEAR(getdate())+1,MONTH(getdate())-11,1);
   
SELECT DATEFROMPARTS(2024,-1,1) AS DateFromParts;