Arno, yes, Opendate and Closedate are in the same record, and in fact I have Cast them as Date (from datetime) to make this query easier.

However, I dont understand the last bit of your answer?

// date range (CLOSEDATE > OPENDATE)

--- In firebird-support@yahoogroups.com, Arno Brinkman <fbsupport@...> wrote:
>
> Hi,
>
> If i understand correctly that Opendate and Closedate is in the same record and they are stored as Dates (not datetime),
> then may be this:
>
> SELECT
> Count(*)
> FROM
> Notemaster
> WHERE
> (OPENDATE BETWEEN '2010-01-01' and '2010-01-10') and // date range
> (CLOSEDATE > OPENDATE)
>
> ?
>
> Regards,
> Arno Brinkman
> ABVisie
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Firebird open source database with many powerful SQL features:
> http://www.firebirdsql.org
> http://www.firebirdsql.info
>
> General database developer support:
> http://www.databasedevelopmentforum.com
>
> Support list for Interbase and Firebird users:
> firebird-support@yahoogroups.com
>
> Nederlandse firebird nieuwsgroep:
> news://newsgroups.firebirdsql.info
>