When applying column filters to a custom list builder list blank dates are included in the filtered results. This is not consistent with functionality in other areas of the application.
This can be addressed by using a Between filter instead of a Before filter. Set the first range of the Between filter to a date far into the past and the Before date into the future, and the null values will not be pulled.
<!-- define the view used to return data for the query --> <ViewImplementation ViewName="USR_V_QUERY_LISTBUILDERTEST"> <ViewSQL> <![CDATA[ Select C.ID, C.KEYNAME, C.FIRSTNAME, C.ISINACTIVE, C.CUSTOMIDENTIFIER, C.DATEADDED, C.GENDER, C.NAME, R.DATE as 'REVENUEDATE', R.POSTDATE as 'REVENUEPOSTDATE', r.AMOUNT From Revenue R Left Join Constituent C On R.CONSTITUENTID = C.ID ]]> </ViewSQL> </ViewImplementation>