Is Null Formula

[lbunch]

How can I check each formula for null else Excpchk will be "Yes"



Whileprintingrecords;
stringvar Excpchk;

if{@SubBorrwrDateFetch}
{@subMasterDateFetch}
{@SubUnitDateFetch} then
Excpchk := "Yes"
else
Excpchk := Excpchk

 

[synapsevampire]

Formulas generally don't return a null, and since you didn't post what's in the formulas, you shouldn't expect meaningful help here.

to check for null, use:

if
isnull({@SubBorrwrDateFetch})
and
isnull({@subMasterDateFetch})
and
isnull({@SubUnitDateFetch}) then
Excpchk
else
Excpchk := "Yes"

btw, using a formula to state

Excpchk := Excpchk

is redundant, there's nor reason to set something to equal what it already equals.

I suggest that you try posting technical requirements and th environment rather than a fragment of the requirements, you would likely benefit from some architectural advice as well.

-k