1. We apologize for the slow support at the moment. Hugh (cheesegrits) is scheduled for some major back surgery this month to repair two ruptured discs which are severely hampering his ability to work, and one of our stalwart community support members is on vacation for the month. Please bear with us.

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