var date1 , date2 : TDateTime; ... SELECT Field1, Field2, Field3 FROM Table WHERE Field1 BETWEEN Date1 AND Date2 ...