On Friday, August 15, 2003 at 14:27, Lightening wrote: L> This is similar to a question I asked earlier except that was an integer, L> this is a date. You guys recommended CInt (which fixed it) back then, so I L> tried CDate now, with no result. This code finds no records, although there L> are records there. L> Can som one help me with this? try wrapping your date in #'s... sql="SELECT HolidayId, HolidayName, TimeOpen, TimeClose, HDate " &_ " from HolidayTable where hdate >= #" & cdate(firstDateOfMonth) &_ "# and hdate <= #" & cdate(lastDateOfMonth) & "#" should work for access... hth, darren.