7 Replies Latest reply on Sep 29, 2016 9:48 AM by David Li

    How to filter and show nulls vs. non-nulls

    Mary Kerrigan

      I have a date column and sometimes the dates are null.  I want to be able to filter to show records where this column is either null or not null with a parameter.  Something like this:


      IF [Parameter] = 1 THEN [Date Field] IS NULL

      ELSEIF [Parameter] = 2 THEN [Date Field] IS NOT NULL



      I'm getting the "IF statement cannot use boolean" error.  I've hunted for the answer online to no avail.  Please help!