if month(CurrentDate) = 1 then

if {table.critieria} = "A"

then

True

Else

False

if( month(currentDate) = 2 then

if {table.critieria} = "B"

then

True

Else

False

 

 

So it always seems to not work, I assume because the variable I am using is not pulling from each record, but rather from the currentdate. In month one, I may want to look at records that match criteria A, but in month two, I want to look at records that meet Criteria B.

 

Is there any way to do this? This is for a report I intend to schedule via Crystal Enterprise so don't want to have to change it constantly as I could have dozens of these running very similarly but for different people.

 

If I run the same report on January, I want it to filter out not equal to A.

 

Then if the same report is reran in february, it switches to look for B.

 

Is this possible?

 

I am guessing it is because Month(currentdate)=2 is valid for every record.