parameters on date

[tnguyen315]

I created a report using CR 11 to show all patients with missing info. on it. I have 3 parameter fields (Zone, BeginDateCompleted, and EndDateCompleted). "BeginDateCompleted" should be greater than or equal "CompletedDate" and "EndDateCompleted" should be Less than or equal "CompletedDate". and "CompletedDate" not a reqired field so some records may have null values.

Below is my record selection formula:

{@Zone} = {?Zone} And {@DateCompleted} in {?BeginDateCompleted} to {?EndDateCompleted} and
isnull({CASE.CASE_STATUS}) or isnull({CASE.Zip}) or isnull({CASE.DOB})
or isnull({CASE.SEX}) or isnull({CASE.ONSET_DATE}) or isnull({CASE.ADDRESS})

When I run this report, between "01/01/09" to "01/31/31" I got the results with all dates included null date also. So please help on how I can run the date parameters on date range. Thanks alots.

 

[tnguyen315]

Just ignored my post...I got it works, should be

{@Zone} = {?Zone} And {@DateCompleted} in {?BeginDateCompleted} to {?EndDateCompleted} and
(isnull({CASE.CASE_STATUS}) or isnull({CASE.Zip}) or isnull({CASE.DOB})
or isnull({CASE.SEX}) or isnull({CASE.ONSET_DATE}) or isnull({CASE.ADDRESS}))