1 Reply Latest reply on Apr 17, 2017 12:38 PM by Devraj Grewal

    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

       

      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?

        • Re: Filter Future Date - Custom Object
          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.

          2 of 2 people found this helpful