Crystal Reports How do you use the select expert to have it return records where a DateField is Null?

Posted on 2011-05-12
Last Modified: 2012-05-11
The is equal to does not accept NULL. Can someone tell me how I can set it so that no records with a CompletionDate are returned?

Thank you!
Question by:J C
    LVL 100

    Accepted Solution

    Try using IsNull

    Null is the absence of a value thus comparing to Null doesn't mean anything since there is nothing to compare.



    Expert Comment

    mlmcc is correct - Basically, you open up the select expert, click Show Formula, Then click the formula editor, and add in the text isnull({CompletionDateField})

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Security Threats Are You Missing?

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
    Hello, In my precious Article  ( saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now