Wrong results reported by Crystal Report

[mjbhopal]

In Crystal Reports,in record selection formula i have entered following formula
({Trans.ReceiptDate} in Date(2001,12,09) to Date(2001,12,09)) or ({Trans.IssueDate} in Date(2001,12,09) to Date(2001,12,09))

This gives only 3 records. As my database contains 8 records of same date in IssueDate field and 3 records of same date in ReceiptDate field. When I give IssueDate condition first and then gives ReceiptDate condition second I get 8 records. Instead of this all 11 records should be reported. Can some body explain it?
-Mahesh

 

[John43]

Use separate dates, not range dates.
set up parameters
field one start date
field one end date
etc.