Sql Tabelle nacht Datum sortiren / Filtern

[Sharky]

Mein Code hatte einige Fehler

Delphi-Quellcode:

procedure TForm1.Button1Click(Sender: TObject);
begin
   with query do
   begin
     SQL.Text := 'SELECT * FROM tabelle ' + #10
                + 'WHERE (datumsfeld BETWEEN :start AND :ende)';
     ParamCheck := True;
     ParamByName('start').AsDateTime := DateTimePicker1.Date;  // DTP 1 für start
     ParamByName('ende').AsDateTime := DateTimePicker2.Date;
     Open;
   end;
end;