Dear All,

IB_Query.SQL := 'SELECT * FROM SalesCall WHERE SCDate>=:dSCFrom AND
SCDate<=:dSCTO'

I got the value of the date range from the standard VCL DateTimePicker.
IB_Query.ParamByName('dSCFrom').AsDate := dtpFrom.Date;
IB_Query.ParamByName('dSCTo').AsDate := dtpTo.Date;
IB_Query.Open;

The result is empty.

Tried with string :
IB_Query.ParamByName('dSCFrom').AsString := DATETOSTR(dtpFrom.Date);
IB_Query.ParamByName('dSCTo').AsString := DATETOSTR(dtpTo.Date);
IB_Query.Open;

Still empty.

How to query based on the date ?

TIA
Andy