Wrong results reported by Crystal Report

[mjbhopal]

In Crystal Reports,in report 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

 

[chelseatech]

It could be worth trying
({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)])

Could NULL's be causing your problem?

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm