select * from 'table' where date1 between '"& datetimepicker1.value &"' and '"& datetimepicker2.value