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

Highlighted
Level 2

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

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

2 REPLIES 2
Highlighted

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

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

Highlighted

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

Review this and and