Compare Date fields in Marketo Smart List

Yun_Bai1
Level 4

Compare Date fields in Marketo Smart List

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

6 REPLIES 6
SanfordWhiteman
Level 10 - Community Moderator

Re: Compare Date fields in Marketo Smart List

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

Jason_Raisleger
Level 4

Re: Compare Date fields in Marketo Smart List

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

Grégoire_Miche2
Level 10

Re: Compare Date fields in Marketo Smart List

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
Level 4

Re: Compare Date fields in Marketo Smart List

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
Level 4

Re: Compare Date fields in Marketo Smart List

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
Level 10

Re: Compare Date fields in Marketo Smart List

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