hi,
thank you very much.

>select cont_date, cust_name, cust_addr from yourtable ;
> where cont_date = gomonth(date(),-6)
>
>>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