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