Query.sql.text:='SELECT * FROM table WHERE date >= ' + datetostr(DateTimePickler1.date) + ' AND date <= ' + datetostr(DateTimePickler2.date); Query.open;