Lead qualifies for Smartlist filter utilizing "on or before" date filter when lead has no date in the corresponding date field
Issue Description
Leads would be qualifying for a Smart List filter that was set up to only qualify those leads that had a date "on or before mm/dd/yy", leads that have null would also qualify for this filter when they should not.
Issue Resolution
When the field is left as null, by default Null value is treated as epoch timestamp (i.e, jan 1 1970). In this case it is recommended to change the filter date from "on or before" to "between" in order to exclude those leads that have null in the date field.
Is this article helpful ?