Filter by current date

[DaggerLily]

I know that I am missing something very, very obvious, but for the life of me, I don't know why this isn't working. I am trying to filter a recordset where one field's date value is equal to or greater than today's date and another field's date value is less than or equal to it's value. I've used this code:

WHERE signupOpen >= CURDATE() AND signupClose =< CURDATE()

but I keep getting an error. I know I'm missing something but I can't figure out what it is! Could someone help?

Thanks

[defanjos]

Try:
WHERE signupOpen >= CURDATE() AND signupClose <= CURDATE()

instead of:
WHERE signupOpen >= CURDATE() AND signupClose =< CURDATE()

It is always the little things :)