Crystal XI - Formula criteria ignored. Why? 1

[ReillyC]

The following formula works great {TABLE_PRODUCT}IN ["TV","VCR","DVD"]THEN 1 ELSE 0
but I needed to modified it. I needed to add one other criteria, date criteria.

IF NOT IS NULL({TABLE_APPLICATION_DATE}) AND {TABLE_TABPRODUCT.CODPRD}IN ["TV","VCR","DVD"]THEN 1 ELSE 0

The problem is that my latest criteria is being ignored completely. It's only displaying the results of this criteria{TABLE_PRODUCT}IN ["TV","VCR","DVD"]THEN 1 ELSE 0

Help

Thanks again,
R

 

[Turkbear]

Hi,
If {TABLE_APPLICATION_DATE} is actually a Date field, then IsNull may not work..Try

IF (
{TABLE_APPLICATION_DATE}<> Date(0,0,0) AND {TABLE_TABPRODUCT.CODPRD}IN ["TV","VCR","DVD"]
)
THEN 1
ELSE 0

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[ReillyC]

Turkbear (TechnicalUser)
Your solution worked great.