یا 

"Select * from Table1 where Date>" & Date1 & " and <" & Date2