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