On this type of query I generally use:

WHERE docdate<cast('today' as date)+1

or

WHERE docdate<(current_date +1)

Luiz.

----- Original Message -----
From: Riho-Rene Ellermaa <r.ellermaa@...>
To: IBObject (E-mail) <IBObjects@yahoogroups.com>
Sent: Friday, June 22, 2001 5:31 AM
Subject: [IBO] Date calculations


> Hi!
> I have a problem that appears only in very rare cases, but it appears...
>
> 'Docdate' is a Timestamp field. I default it to "now". The column
properties
> are set to NO TIME.
>
> In other query I have:
> WHERE docdate<='today'
>
> In most cases this works, but 1...5 customers are having problems - i.e.
the
> todays records are not selected.
> When I look my table with some Interbase tool, then I see field values
only
> as 22.06.2001, without time part as it should be.
>
>
> I try to change the 'now' to 'today' and hope this helps, but the question
> remains - what's the reason?
>
> Riho-Rene Ellermaa
> senior programmer
> Hansabank
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>