Answer 1

--Get 3 month from now:
DECLARE @threemonthago
SET @threemonthago = DATEADD(MONTH, -3, GETDATE())

SELECT * FROM table WHERE record_date >= @threemonthago