Date filter for today + XX days | Community
Skip to main content
A
Anonymous
February 9, 2015
Solved

Date filter for today + XX days

  • February 9, 2015
  • 6 replies
  • 4536 views
Regarding date fields, is there a way to filter on "today + xx days"?
EX:  I have a smart campaign that will email leads when their LastIssueDate (custom date field) is exactily 40 days from today.  Currently I am using the "In future = 40 days" AND "In future after = 39 days", but this isn't optimal for other scenarions.   This campaign runs daily, so I cannot manually enter a specific date each day.  Any suggestions?
 
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
We're planning to enhance the date filter soon and this is one area that I'd like to improve. For now, what you have should work. 

Is there something you're trying to do but can't?

6 replies

Casey_Grimes2
Casey_Grimes2
New Participant
January 12, 2018

Hi Devaraj,

In this case, you would use something like {{system.date}}.

A
Anonymous
January 12, 2018

Did Marketo enhance the date filter to support "today + x days" logic?

Casey_Grimes2
Casey_Grimes2
New Participant
January 12, 2018

Hi Devaraj,

In a word: yes. Adding a formula in a flow such as End Date = {{lead.Start Date}} + 40 days is recognized by Marketo to calculate the data value as 40 days after the Start Date value.

A
Anonymous
January 12, 2018

Thanks for your response Courtney!

So is there a token to pull the current date? I want to do something like if {date} = Today + 7 then send the email where {date} is a custom field in the lead.

Caryl_Mostacho
Caryl_Mostacho
New Participant
October 8, 2015

Hi @Nancy Demers​ - In the past, I have used a counter field that updates every day by +1 for a campaign similar to this. You can then run a batch campaign for your email to send based on when this counter field is = 40. 

Dory_Viscoglio
Dory_Viscoglio
New Participant
February 10, 2015
The "In Future after" and "In Past before" filters were a great addition. One thing that would be nice is to be able to filter by hours instead of days in more places. 
    A
    Anonymous
    February 10, 2015
    Thank you for the response.  What I'm doing now seems to work, but it would be optimal to have the ability to calculate a date based on a delta timeframe from sysdate.   I will wait for the enhancements.
    Justin_Cooperm2
    Justin_Cooperm2Accepted solution
    New Participant
    February 9, 2015
    We're planning to enhance the date filter soon and this is one area that I'd like to improve. For now, what you have should work. 

    Is there something you're trying to do but can't?
      Terms & ConditionsAccessibility statement

      Loading footer...