Quick question on Date=Today

Am just trying to add a WHERE clause to a query to display records based on the current date.

There are two pages - one for Past Events, and one for Future Events.

So the jist is that an event is added once, with its date, and will automatically move from the Future Events page to the Past Events page.

I've been trying to look up the syntax, but haven't quite got it.

I thought it was something like:

WHERE EventDate>=date('today') or WHERE EventDate>=date(Now) or WHERE EventDate>=NOW()

I've tried a few variations, but not got it working.

Am I getting warm?

Actually, just using:

WHERE EventDate<NOW() and WHERE EventDate>NOW()

Seems to be working fine for past and future.

glad to hear you found it.