Skip to main content
Yun_Bai1
Level 4
July 25, 2018
Question

Compare Date fields in Marketo Smart List

  • July 25, 2018
  • 2 replies
  • 4634 views

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

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

2 replies

SanfordWhiteman
Level 10
July 25, 2018

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

Jason_Raisleger
Level 3
July 26, 2018

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

Grégoire_Miche2
Level 10
July 26, 2018

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

Jay_Jiang
Level 10
July 26, 2018

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