SOLVED

Filter Future Date - Custom Object

Go to solution
Highlighted
Level 2

Filter Future Date - Custom Object

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

Screen Shot 2017-04-17 at 10.21.21 AM.png

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

Any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Re: Filter Future Date - Custom Object

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.

View solution in original post

1 REPLY 1
Highlighted

Re: Filter Future Date - Custom Object

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.

View solution in original post