[RESOLVED] VB6 & Access 2000 Date compared to date issue

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

With "Access" databases the ' delimiter is only for text values, use # for date values.

thanks again SI. that did it.