hi all,

i need to select cont_date, customers names ,customers adress...etc

befor six month .

if date is 01/07/2007
cont_date cust_name cust_addr
01/01/2007 aaaa ........
.
.
************************************
if date is 02/07/2007
cont_date cust_name cust_addr
02/01/2007 bbbb ......... .
.
.

thanks