Using the date operators | Community
Skip to main content
N
Nicol_Maurer
Level 3
November 18, 2015
Solved

Using the date operators

  • November 18, 2015
  • 3 replies
  • 6267 views

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.

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

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

3 replies

Justin_Cooperm2
Justin_Cooperm2Accepted solution
Level 10
November 18, 2015

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

    N
    Nicol_MaurerAuthor
    Level 3
    November 19, 2015

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

    Grégoire_Miche2
    Grégoire_Miche2
    Level 10
    November 18, 2015

    HI Nicol,

    Use the "In Past before" operator.

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

    -Greg

      N
      Nicol_MaurerAuthor
      Level 3
      November 19, 2015

      Thanks for your help, Gregoire!@Grégoire Michel

      A
      Anonymous
      October 12, 2017

      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.

      Terms & ConditionsAccessibility statement

      Loading footer...