Only Todays Dates

Hi, Trying to create a board that only displays todays records out of the database and can't get it to work.

CurrDate = Date()
x = Date()
y = Date() + 1

sql = " SELECT * from calender_event "
sql = sql & " where (('" & x & "' >= start_dt) and ('" & y & "' <= end_dt))"
sql = sql & " or "
sql = sql & " (('" & y & "' >= start_dt) and ('" & x & "' <= end_dt))"

--> SQL_query = "SELECT * FROM calender_event WHERE start_dt = " & CurrDate

Can anyone help?

Thanks Nick

What database are you using?

Its a Access Database.