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

[seanwpb]

i cant get this simple query to work

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

[si_the_geek]

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

[seanwpb]

thanks again SI. that did it.