Formula help Date Field IS NULL 1

[Tailgun]

I have a report Crystal 8.5 I need a formula for the record selection. IN SQL this works

SELECT * FROM tblClaim WHERE NOT (AppraiserLastName IS NULL) AND DateClosed IS NULL

However in Crystal the first part works

{tblClaim.AppraiserLastName} <> &quot;NULL&quot;

But I can't figure out how to use DateClosed IS NULL. When I try to enter it it wants only date information since it is a date field. Is there a workaround for this in the Crystal formula ?? Thanks for any help.

 

[dgillz]

Not IsNull({AppraiserLastName}) and IsNull({DateClosed}) Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[Tailgun]

Thanks after I added the tbl names it works perfectly.

Thanks again