We help IT Professionals succeed at work.

crystal null value

evend
evend asked
on
I have a field called "Out Of Service Date"  I want to see all customers without a date entered in it and or filter out any that do.    When I setup a parameter to select a customer I do not want to see any customers with a out of service date basically?

tx
Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
To select all customers with NO out of service date

IsNull({OutOfServiceDateField})

To get customers WITH an out of service date

  NOT IsNull({OutOfServiceDateField})

mlmcc

Author

Commented:
Perfect!

Explore More ContentExplore courses, solutions, and other research materials related to this topic.