filtering by Date in Recordset

[cdlcruz]

I want to filter displayed records,showing only dates equal to or greater than
"today".

SELECT *
FROM tblEvents
WHERE eventDate >= **** this is where I need the syntax to place today's
date.
ORDER BY eventDate ASC

If it matters, I am pulling data from an MS Access table.

Thanks.
Catherine de la Cruz

[Julian Roberts]

Try

SELECT *
FROM tblEvents
WHERE eventDate >= Date()

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[cdlcruz]

thank you