i cant get this simple query to work

Code:
rs.Open "Select * From BoardSlides WHERE SlideDisplayOnlyDate = '" & Format(Date, "mm/dd/yyyy") & "' ORDER By SlideName", connLoadLabel, adOpenForwardOnly, adLockReadOnly



SlideDisplayOnlyDate field is a datetime field, but i get a data type mismatch in criteria expression error. SlideDisplayOnlyDate holds a date and when the app is ran and that date happens to be todays date then i want to return those records. what am i doing wrong? thanks in advance