Hello Bill,

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

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

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

What is the data type of RCPTDATE (and what is the DB SQL dialect)?
For TIMESTAMP data type, '06/30/2006' would be cast to '06/30/2006
00:00:00', i.e. the beginning of the day.


--
Best regards,
Pavel Menshchikov
http://www.ls-software.com