Lead qualifies for Smartlist filter utilizing "on or before" date filter when lead has no date in the corresponding date field

A document by KCS Integration on behalf of e18ca6f806e6576960207ce7ac126a4f904f6c57 on Mar 13, 2018Last modified by Vishal Sharma on Jun 26, 2018
Version 3Show Document
  • View in full screen mode

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 ?