displaying null values 1

[gojohnnygogogogo]

Hello,
I am connecting to an Oracle database and in my select expert I want to put where end_date is null, however, when I try that I get an error saying date required.

any ideas ?

thanks a lot.
J

 

[dgillz]

Do not use the select expert, write a record selection formula instead. Clickon report, edit selection formula, record and write your formula:

IsNull({Datefield})

the you will only see records with no dates in your date field. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[gojohnnygogogogo]

thank you dgillz, that is perfect