Where clause to bring back future

Please excuse me if I get too detailed in this.&nbsp;&nbsp;I am using DB2 and I am trying to query our sales date field (formated as date) and bring back results of all sales that happened in the past, for the next three months.&nbsp;&nbsp;Short story is we are trying to automate our subscription renewal process and need to send out letters for renewals at least three months in advance.&nbsp;&nbsp;The fields have the purchase date, mm/dd/yyyy that can range anywhere from 1995 to present.&nbsp;&nbsp;I need a query that will pull all customers who's renewals are due within the next three months.&nbsp;&nbsp;If anyone can help that would be greatly appreicated.&nbsp;&nbsp;<br><br>RBE