oracle8.1.6 and sysdate-g.issue_date <= 1 and sysdate-g.issue_date <= 7 and months_between(sysdate,g.issue_date) <= 1