Is there a way of creating a BETWEEN feature for Powerlists? I.E. I want BETWEEN X and Y days.

  • 1
  • Question
  • Updated 2 months ago
  • Answered
Photo of Chris Hughes

Chris Hughes

  • 206 Points 100 badge 2x thumb

Posted 2 months ago

  • 1
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,788 Points 1k badge 2x thumb
Hey Chris - 

Assuming you have a date field (maybe created date) on the Contact object, you could do this with logic on the Powerlist.

Photo of Ben

Ben, Champion

  • 8,076 Points 5k badge 2x thumb
Ack you beat me Tim! Nice work.
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,788 Points 1k badge 2x thumb
Ha! Great minds. : )
Photo of Chris Hughes

Chris Hughes

  • 206 Points 100 badge 2x thumb
We have a field for Days Until Renewal and want to say Days Until Renewal (under Customer Info) between X and Y and it hasn't worked for us consistently.  Would we need to move the field under Contact or Account for us to achieve the above?
(Edited)
Photo of Tim Schukar

Tim Schukar, Employee

  • 1,788 Points 1k badge 2x thumb
Hey Chris - 

I would recommend you use Advanced Outreaches (aka Journey Orchestrator).  You can build a list of contacts via the Query Builder that allows you to bring in various data sets just like a bionic rule.  That way, you could associate those dates on the account and/or contact level.
Photo of Ben

Ben, Champion

  • 8,126 Points 5k badge 2x thumb
This should be possible by using two date filters, one with greater than your oldest date and the one with less or equal to your soonest date. If you want a rolling window, you could do the same thing but incorporate the "Subtract X days from Rule Date" feature.

Happy to help if you have more specifics!