I am using the predicator between..and to retrieve a list of
payments between 2 dates:

select RCPTDATE, RCPTAMOUNT
from DEBTORPAY
where RCPTDATE between '06/01/2006' and '06/30/2006'
order by 1

The result only lists all receipts between '06/01/2006'
and '06/28/2006' inclusive. The table does contain records for the
30th June - why aren,t they retrieved.

I am having this problem using IBX components in Delphi 5. Also get
same result using this query in IBExpert so assume this is not a
problem with the IBX component.

thanks in advance

Bill