Fantastic!
Thank you so much.
One final question and I'll be extremely happy if you will be able to answer this question.
"SELECT * FROM customers_tbl WHERE CURDATE() >= ContractEnd - INTERVAL 30 DAY"
The above will let me know customers who have to renew their contract in less than 30 days and it will display all the records below the +30 days
So far very good
I will like to control this by stopping on -30 DAY.
So the records will be +30 and -30
At the moment it shows every single record below the +30 including contracts have ended in 2005
Is this possible?
You will be the best programming helper if you will be able to give me the answer.
Looking forward for the answer.
THANKS THANKS THANKS!!!