General information
Category:
Coding, syntax & commands
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only