Advance date query
Can you please let me know the command that will enable me to find all the customers WHERE contractEnds in the next 30 days?
Here is my current query:
------------------------------------------------
SELECT BusinessName, ContractStart, ContractEnd
FROM customers_tbl
WHERE ContractEnd <= 30
-------------------------------------------------
About the ContractEnd field: I use MySQL and the field is set as DATE
Year-Month-Day
0000-00-00
I will really appreciate your help.
Thanks