On 22-6-2013 01:42, Alan J Davies wrote:

> Where do you declare "today"?
>
> This is an example:
> select datediff( day, (select current_date from rdb$database), (select
> current_date-10 from rdb$database))
> from rdb$database
> gives an answer of -10
> so if you substitute this code:
>
> > datediff(day, (select current_date from rdb$database),
> w_shipments.begin_fill_date)
>
> that will work if you have no other errors.

You can use current_date directly in a query, there is no need to select
current_date from rdb$database, so this will work as well:

select datediff(day, current_date, current_date-10)
from rdb$database


--
Mark Rotteveel