Denise Greenberg

Be Careful with "Is before" and "In past before" date field operators - they include records where the date field is empty

Discussion created by Denise Greenberg on Sep 24, 2018
Latest reply on Dec 4, 2018 by Denise Greenberg

Hey Everyone - Be careful using "Is before" and "in past before" date field operators. Marketo Support has just informed me that it is expected behavior for the date field operators "is before" and "in past before" to qualify records where the date field is empty!


In other words - suppose the person was never synced to SFDC. This Smart List does not come up empty. You have to add an additional filter for SFDC Created Date is not empty.


The same thing applies to this example:


Since has an empty SFDC Created Date, you'd expect the smart list to turn up empty - but it doesn't. It contains


Obviously this isn't my real use case. I'm just using the above as a simplified way to describe the situation. I discovered this behavior when a couple of segments I created having to do with end dates for certain products contained unreasonably large numbers of people. I will be creating an idea around this and will add a link to it to this thread when I do.