Show Recordset Based On Current Date

I want to call a recordset based on whether the 'expiration_start' date and 'expiration_end' date are within the current date.

I've tried a few things but can't get it to work?

Here's my non-working SQL statement:

Code:

sSQL = "SELECT * FROM poll WHERE #" & date & "# BETWEEN expiration_start AND expiration_end"


I'm simply using 'date' to call the current date. I'm not sure if that's correct but it seems to work ok when I use it in an "if" statement like this example: