Thank's for the reply.

The field is in Date type and I'm using the English-United States settings,
that is month/day/year.
So I don't think it will solve the problem.

Warm regards
Andy

----- Original Message -----
From: "Ondrej Kelle" <O.Kelle@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, March 12, 2001 2:55 PM
Subject: RE: [IBO] Date issue ( again )


> If SCDate is a timestamp field I think you should try
>
> SELECT * FROM SalesCall WHERE CAST(SCDate AS DATE) >= :dSCFrom AND
> CAST(SCDate AS DATE) <=:dSCTO
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>