Using the date operators

[Nicol_Maurer]

I tend to overthink these a lot, so I need clarification. I've been asked to put some constraints on an existing smart list to EXCLUDE anyone with an approval within the last 30 days. The field is LatestApprovalDate. Should I be using the LatestApprovalDate in past before 30 days? Or LatestApprovalDate before 30 days? Or maybe even a fancy formula? I'll take any suggestions, as the more I analyze it the less sense it makes.

[Justin_Cooperm2 · Accepted solution]

in past before 30 days is what you want. If you use "before" you need to enter an explicit date.

[Nicol_Maurer]

Thanks, Justin! Sometimes I just need to get out of my head!

[William_Moudry1]

I need to do the same thing (on the Lead Was Created field), but the "in past before" operator is not available. Has this been removed from Marketo? Is there a replacement?

[Grégoire_Miche2]

Hi William,

It has not been removed, it just has never been there on the lead was created filter.... In fact "In Past Before" and "In future after" are only available on date fields, not in the "date of activity" constraint on activity filters.

You may want to use the "Created at" date filter.

Or you can combine the "lead was created" and "not lead was created" with different time frames.

-Greg

[William_Moudry1]

Thanks, Greg! I ended up getting there with 2 lists. I set up one Smart List that finds leads created "in past" "6 months". Then I set up a second Smart List that finds leads not in the first list. But using "Created at" with "in past before" is simpler.

[Grégoire_Miche2]

HI Nicol,

Use the "In Past before" operator.

See here : Smart List Filter Operators Glossary - Marketo Docs - Product Docs

-Greg

[Nicol_Maurer]

Thanks for your help, Gregoire!Grégoire Michel

[Anonymous]

Hi Gregoire,

If I want to specify people who were created longer than 12 months ago, would I use the "in past before 12 months"?

[Anonymous]

Is it possible to specify time of day on a specific date when using the "on or after" operator? For example, do x for all people who registered on or after 10/12/2017 2:00PM? From what I've seen, you can only use hours when using "in past," using "on or after" only allows you to specify the day.