In Future Filter Not Working Against Custom Object Date Field | Community
Skip to main content
Sean_Hardaker
Sean_Hardaker
New Participant
November 24, 2016
Solved

In Future Filter Not Working Against Custom Object Date Field

  • November 24, 2016
  • 2 replies
  • 5934 views

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

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Grégoire_Miche2

Hi Greg

I'm confused. The two filters refer to the same custom object "Platform Accounts".  Do you mean that the two filters are doing two separate filters and combining the results?

What about this example from the Makreto docs?

Say you want to see customers who are up for renewal in 90 days. You would use two separate filters. First use "In Future After 90 days," and second, "In Future 91 Days." That would capture whomever has a date 90 days from now.

Smart List Filter Operators Glossary - Marketo Docs - Product Docs

thanks

Sean


HI Sean,

Although the filters apply to the same object, they do not retrieve the same custom object records.

Marketo example works on lead fields, not on custom objects fields, since, on lead fields, there is only one value to filter on, so both filters apply to the same value.

-Greg

2 replies

Jared_Kimball2
Jared_Kimball2
New Participant
January 5, 2018

Okay, now I understand. Thanks for clarifying.

Grégoire_Miche2
Grégoire_Miche2
New Participant
November 24, 2016

Hi Sean,

Can you please provide a screnshot of the filters?

the 4 other leads have to have some Custom objects with different dates. What are these dates?

I suspect that your 4 leads have more than one custom object attached and that for instance, they may have 1 record on the 26th and another one on the 28th.

The 2 filters together do not filter on the same custom object record...

-Greg

Sean_Hardaker
Sean_HardakerAuthor
New Participant
November 24, 2016

Grégoire_Miche2
Grégoire_Miche2
New Participant
November 24, 2016

Yes, this is exactly what I suspected. As expected, the 2 filters do not apply to the same custom object, so if a lead has 2 records, it migt be select even though there is no record in exactly 3 days.

I do not see a solution to your problem in the absence of "Not in future" and "Not in future after" operators that would enable to select all leads without a custom object on the 27th and then use any leads not fitting this.

-Greg

Terms & ConditionsAccessibility statement

Loading footer...