In VB 6.0 im just using (select * from table where date between date1,date2) or (select * from table where date > date1 and date < date2)

how about in VB.net????