Filter Future Date - Custom Object | Community
Skip to main content
Joseph_Long
Joseph_Long
New Participant
April 17, 2017
Solved

Filter Future Date - Custom Object

  • April 17, 2017
  • 1 reply
  • 1566 views

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?

    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 Devraj_Grewal

    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.

    1 reply

    Devraj_Grewal
    Devraj_GrewalAccepted solution
    New Participant
    April 17, 2017

    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.

      Terms & ConditionsAccessibility statement

      Loading footer...