Problem Using Date As Filter For Record

I am trying to filter a recordset by 3 fields. character name, username, and date.

(some of you may have seen this who have helped me on a few other problems. You guys rock!)

The query runs fine, until I introduce the date element. It says that my syntax is incorrect. I am trying this.

"Select * from fieldname Where valueOne = Request.Querystring("value") and valueTwo = Request.Querystring("value2") and date = date()"

I am sure this is blatantly obvious to some of you, but i can't get it to work. I have put date in a variable:

Dim currentDate
currentDate = date()

and tried "... where date = currentDate"

Any suggestions?