I have an event calendar and I would like to filter records in a recordset by what month they belong to.

I tried WHERE Datoevent = MONTH(CURDATE()) but that wouldn't work.
I would also like to know how the script needs to change if I were to filter by next month. I guess MONTH(CURDATE)+1) wont work...

Thanks in advance for any help

.:. DWMX .:. MS IIS 5.1 .:. WinXP .:. MySQL .:. ASP VB