Smart list date filters and token: "Date field 1" is before "Date field 2" | Community
Skip to main content
Hoi_Nguyen3
Hoi_Nguyen3
Level 2
May 18, 2018
Question

Smart list date filters and token: "Date field 1" is before "Date field 2"

  • May 18, 2018
  • 2 replies
  • 2636 views

Hi Community,

Is it possible to set up a smart list filter where it basically says something like:

Opportunity Created Date is after Lead Created Date.

Right now, I'm seeing that Marketo only allows hard date values when using date filters in smart lists.

I'm trying to figure out how to leverage tokens to do this but I'm coming up blank.

Any ideas would be much appreciated.

Thanks,

Hoi

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

2 replies

Grégoire_Miche2
Grégoire_Miche2
Level 10
May 18, 2018

This is not possible out of the box. It would take the possibility to use a token as a filter criteria, which is not possible.

Try to create a third field and populate it with {{lead.date 1}} - {{lead.Date 2}} but I am pretty sure that will not fly.

So you will need to use some webhook technology to compute the difference between the 2 fields or compare them and return a true-false.

-Greg

    Grégoire_Miche2
    Grégoire_Miche2
    Level 10
    May 18, 2018

    Review this and and  

    Terms & ConditionsAccessibility statement

    Loading footer...