1. Hugh is (technically) on vacation for the rest of September, travelling to Europe for his son's wedding in England, and to meet up with Rob in La Rochelle, France. He will be checking the forums most days, and providing some support, but his time will be limited, and he will be unable to do any custom coding work. Apologies in advance for any inconvenience.

Pre-filter with condition IS NOT NULL not working

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

  1. productid

    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"
    VALUE: No Quotes

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

    Please help! Thank you.:)
  2. productid

    productid New Member

    Level: Community
    friendly bump

    It has been 5 days since I posted.
  3. troester

    troester Well-Known Member Staff 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