Smart list filter on anniversary date = yesterday | Community
Skip to main content
Jo_Pitts1
Community Advisor
Jo_Pitts1Community Advisor
Community Advisor
September 4, 2019
Solved

Smart list filter on anniversary date = yesterday

  • September 4, 2019
  • 1 reply
  • 3714 views

Hi there.  I am having a mental block (grrrr!).

I want to have a smartlist that includes records where a certain date is YESTERDAY (or for that matter {{System.date}} - 1)

I can't use in past 1 day, because that ends up including records where the anniversary date field is today.

What dumb thing am I forgetting today ??

Regards

Jo

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 Jo_Pitts1

All,

I found the answer... it is to use the 'in timeframe' option and set the value to 'yesterday'.

Cheers

Jo

1 reply

Jo_Pitts1
Community Advisor
Jo_Pitts1Community AdvisorAuthorAccepted solution
Community Advisor
September 4, 2019

All,

I found the answer... it is to use the 'in timeframe' option and set the value to 'yesterday'.

Cheers

Jo

    SanfordWhiteman
    SanfordWhiteman
    Level 10
    September 4, 2019

    Just keep (maybe in the deep back of your mind, in this particular case) that dates, in reality, have timezones. And people in Marketo have Person Timezones, too. But you're going to be getting the "instance yesterday" as opposed to the "person yesterday".  Test a bit and you'll see what I mean.

    Jo_Pitts1
    Community Advisor
    Jo_Pitts1Community AdvisorAuthor
    Community Advisor
    September 4, 2019

    Sanford,

    Yep well aware of that.

    The next part of the issue is how to act on an anniversary exactly x days in the future.

    Cheers

    Jo

    Terms & ConditionsAccessibility statement

    Loading footer...