"Uli Becker" <johnmuller54@googlemail.com> wrote in message

> sql.add('SELECT ...WHERE OrderDate BETWEEN romDate AND illDate');
> ParamByName('pFromDate').asDate := MyFromDate;
> ParamByName('pTillDate').asDate := MyTillDate;

Yes this behave better
Thanks Sorin