Which flavour of SQL are you using? MS-SQL, MySQL, Oracle?
If it’s MySQL, it could be like:
SELECT *
FROM tableA
WHERE expiryDate BETWEEN (current_date and ADDDATE(CURRENT_DATE, INTERVAL 8 DAY))
/* BETWEEN is inclusive - includes dates of range, not just dates between)*/
HTH,
