Compare Date fields in Marketo Smart List

[Yun_Bai1]

Hello Marketo expert,

We are trying to find leads who has the Date 2 happened after Date 1.

For example: we have "sign up date", "status changed date". We are trying to find those status changed after they signed up.

Is that possible to compare two date fields in a Smart List? Or can we create a new integer field with value filled with "status changed date" minus "sign up date"? Or there is other way around?

Thanks,

Becky

[SanfordWhiteman]

You can only compare field values like this using a webhook.

[Jason_Raisleger]

Is that in the developer docs or is it through external sources?

[Grégoire_Miche2]

Hi Jason,

You can find some info about webhooks here: http://developers.marketo.com/webhooks/ But this is about how to call webhooks. You will also need a webhook service. Search the launchpoint for this.

-Greg

[Jason_Raisleger]

Thanks Greg!

Yun Bai​ I need to do something similar. I found CALCITNOW - Field formula calculations » Marketo LaunchPoint®  and looks like they can do what we need but will need to investigate further. Would also love it if anyone else has launchpoint suggestions

[Yun_Bai1]

Thank you for sharing what you found in LaunchPoint. It seems pretty cool. I will keep you posted once I tried it. Good luck on your side too!

[Jay_Jiang]

Not possible in a smart list yet. Best to export and compare in excel