Hi Swapnil 2009,
Small changes in your query
select * from retinvoice
where retinvoice.CREATEDDATE > '08/27/2010' and
retinvoice.CREATEDDATE < '08/29/2010'
My suggestion use between operator also you can achieve your output.
select * from retinvoice
where retinvoice.CREATEDDATE between '08/27/2010' and
'08/29/2010'
Cheers :)