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?
You can only compare field values like this using a webhook.
Is that in the developer docs or is it through external sources?
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.
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
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!
Not possible in a smart list yet. Best to export and compare in excel