I'm trying to execute a query to a MySQL database. The intended result is to return all rows where the date field has a date equal to or greater than todays date.

Here's the query:

SELECT * FROM Seminars WHERE Seminar_Date >= '" & Date() & "' ORDER BY Seminar_Date ASC

For some reason, the query is returning all rows in the table vs. just the rows from today forward.

Any thoughts?

-Steve

have you checked you system date time settings are correct? Your statement looks ok to me.

If you hard code a date, do you get the results you want?

BTW: A statement defaults to ASC, there is no need to include it.

Wind is your friend
Matt