I'm trying to create a report using Crystal 11 based on 5 different date fields. I'm trying to pull data if any one of the five = currentdate.   I can get Date1 = currentdate, or Date2 = currentdate to display, (just one date at a time) but not all 5. Each date field can have data in them, so I want to display them all if one of the dates is equal to today, along with other data like customer name, etc. Any suggestions or formulas that anyone knows to do this?

I have tried this and still it will only return one date - whichever I put first in the formula.

I've tried creating a group and parameter value/select criteria with the same results - if {table.date1}=currentdate then 1 else if {table.date2}=currentdate then 2.... {@dategroup}={?dateparm} and selecting all values 1-5 to display.

I've also tried creating separate sub-reports for each date field and linking to the main report (using a cust id that's in all tables) and the report seems to get stuck in a cycle and just keeps refreshing and never displays all records.

I'm pulling the data from a very large oracle db and the date fields are in a couple different tables. Is there possibly a formatting issue that I need to address first?

You got it right! I actually just figured it out myself, there are null values that were throwing it off since I wasn't accounting for them. Thanks for the help.