You could use the DATEADD function to get the desired result:
SELECT *
FROM table
WHERE paydate >= DATEADD(month, -3, GETDATE())
AND credit < 10
You could use the DATEADD function to get the desired result:
SELECT *
FROM table
WHERE paydate >= DATEADD(month, -3, GETDATE())
AND credit < 10