I have same table as MonthlyDetails which have coulmn as MonthYear and Amount.
Check the below stored procedure query for your referance.
-- EXEC GETMonthlyDetails
CREATE PROCEDURE GETMonthlyDetails
AS
BEGIN
SELECT MonthYear , Amount
FROM MONTHLYDETAILS
WHERE CONVERT(DATETIME,(DATENAME(month,MONTHYEAR)+ DATENAME(year, MONTHYEAR)))
< CONVERT(DATETIME,(DATENAME(month, GETDATE())+ DATENAME(year, GETDATE())))
END
GO