Null v. Empty in CR Formula 1

[cwsstins]

Hi,

I'm working with CR 8.5 and I'm using a formula to display data from a string field only if it's empty or null.

This is what I've got:

({ASGNMNT.DATEACKNOW} = '' or {ASGNMNT.DATEACKNOW} = "" or
isnull({ASGNMNT.DATEACKNOW})

Seems like it should work, but I'm getting less records (in fact, zero records) than I get in the application. Is there another way to extract empty field values other than what I've got listed here?

Thanks,
stinsman

 

[Katy44]

This may be the problem:

if the record is null, it will only get as far as evaluating: {ASGNMNT.DATEACKNOW} = '', which it will evaluate to null, and then it will stop. Try:

(isnull({ASGNMNT.DATEACKNOW} or {ASGNMNT.DATEACKNOW} = '' or {ASGNMNT.DATEACKNOW} = "")

does that give you the results you would expect?

 

[cwsstins]

Katy44, you rock. That did the trick!

Thanks,
stinsman