1. Hugh is now back at work, more or less full time, after a slower than expected recovery from his neck surgery early this month. Obviously we have a backlog of support to clear, and are working as hard as we can to take care of it. If you have an unanswered thread more than 3 days old, please post one (and only one) "bump" on it, to move it in to our "last 3 days" list. If you have an unanswered issue in a forum you no longer have access to due to subscriptions timing out, please use the Contact Us form, and provide us with the URL to the thread.

Pre-filter with condition IS NOT NULL not working

Discussion in 'Table templates' started by productid, Apr 4, 2012.

  1. productid New Member

    Level: Community
    I want to filter records from my table view where the element "discharge date" is empty. In other words, I only want to see records that have a discharge date present.

    I have set up a table pre-filter with the following:

    WHERE: "Discharge Date"
    CONDITION: IS NOT NULL
    VALUE: No Quotes
    APPLY FILTER ON OR BENEATH: Everyone

    It is not filtering out the records without the discharge date present.

    Please help! Thank you.:)
  2. productid New Member

    Level: Community
    friendly bump

    It has been 5 days since I posted.
  3. troester Well-Known Member

    Level: Standard
    You should post in Bronze forum and it's Easter weekend.
    Empty is not necessarily NULL. You can check directly in the database (phpMyAdmin) if your dates are empty, NULL or 00:00:00.

Share This Page