AnsweredAssumed Answered

In Future Filter Not Working Against Custom Object Date Field

Question asked by 9961c78d12d9b96567137448d8b8fba6da13e082 on Nov 24, 2016
Latest reply on Nov 24, 2016 by 9961c78d12d9b96567137448d8b8fba6da13e082

Happy thanksgiving!

 

I’m having a serious problem getting a filter to work properly against a date in a custom object.  I want to filter leads with a record in a custom object with a date 3 days in the future (27th Nov). 

 

the filter "Has OBJECT NAME" -> "DATE" = "In future" 3 days

the filter "Has OBJECT NAME" -> "DATE" = "In future after" 2 days

(ref http://docs.marketo.com/display/public/DOCS/Smart+List+Filter+Operators+Glossary )

 

if I add the email filter to match just on my email address it works fine as I have 1 record in the custom object with the date 27th Nov.

 

If I remove the filter for my email address it returns 4 other leads as well that do not have a custom object record with the date 27th Nov

 

Any ideas what's going on?

thanks

Sean

Outcomes