CR9 Date Parameter - Retrive Records from Multiple Fields

I having a table which has "previousDate", "nextDate" fields in it (Date/Time - Access 2003). In CR9 I created a datetype parameter (SelDt). Now I want to set the parameter to connect to both the above two fields datefields. I opened the select expert and selected the previousDate. Then I opened the formula Editor found in the select expert dialog and added

Quote:

---

or {Table1.nextDate} ={?selDt}

---

assuming it would check for both the fileds and populate the records accordingly. The final code/formula looks like this

Quote:

---

{Table1.previousDate} ={?selDt} or {Table1.nextDate} ={?selDt}

---

when I ran the report I saw all the records being displayed instead of the ones being selected by the user from the prompt dialog. Individually if only one field is used in the parameter it works fine, but when combined it throws out all data.
Note: I donot want to use two parameters.
Any ideas where I am going wrong. :confused:

No need to use parameter can you simple use the SQL query I show in my crystal report tutorial at my signature.

Thanks I did it the same way. But just for knowledge I'd like to know if it is possible by using parameters