[求助]BETWEEN问题

begin
query1.Close;
query1.SQL.Clear;
query1.SQL.Add('select*from 交易 where BETWEEN '''+datetostr(datetimepicker1.Date)+''' and '''+datetostr(datetimepicker2.Date)+'''');
query1.Open;
end;

提示表达式错误!!
谢!