How to selecting data where the date is with the next month or later I want to display all data where the the expiry date is within next month or later, here is my code:

&lt;cfquery name="ExpiryDate"&gt; 
        SELECT * 
        FROM Date
        WHERE Expiry &gt;= 

&lt;/cfquery&gt;
This is what you want:

    SELECT * 
    FROM Date
    WHERE Expiry &gt;= DATE_ADD(curdate(), INTERVAL 1 MONTH);


MySQL date and time functions are documented here.