adoquery1.Close;
adoquery1.SQL.Clear;
adoquery1.SQL.Add('select * from table1 where field between ara1 and ara2');
adoquery1.Parameters.ParamByName('para1').value:=DateTimePicker1.Datetime;
adoquery1.Parameters.ParamByName('para2').value:=DateTimePicker2.Datetime;
adoquery1.open;