Filter Future Date - Custom Object

[Joseph_Long]

Hey Everyone,

Trying to create a batch campaign that will filter on a future date. The filter being used is a custom object in SFDC. 

I'm following the recommendation outlined in the Smart List Filter Operators Glossary, however, I am not returning and results.

Using in future 106 days followed by in future 107 days returns results but they are incorrect and do not coincide with the Marketo documentation.

Screenshot

Expected Behavior: Return results for contacts with a renewal date on 8/1/17
Outcome: Returning result no results at all.

Any suggestions?

[Devraj_Grewal · Accepted solution]

Joseph,

Is 8/1/17 107 days from now? If so, this logic would work as you are filtering by that date having to be after 106 days but also in the future 107 days, which means, only results for 107 days in the future will populate. I would confirm you have records that have 8/1/17 as a value for that field.