Using the date operators

9 replies
6266 views
Translate

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.

Marketo

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

Justin_Cooperm2Accepted solution

Level 10

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

A

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.

Translate