[CarlosHernandez]

sin usar sql seria algo asi:

table1.Filter:= 'fecha >='''+formatdatetime('dd/mm/yyyy',datetimepicker1.DateTime) + ''' and fecha<='''+formatdatetime('dd/mm/yyyy',datetimepicker2.DateTime)+'''';
table1.Filtered:=true;