How to set a date field to today in program smart list? | Community
Skip to main content
Kerry_Risley
Level 1
February 12, 2018
Question

How to set a date field to today in program smart list?

  • February 12, 2018
  • 5 replies
  • 9494 views

We have a date field that must be set as today's date in order for the Smart List to yield the correct results. We are using this for a set of recurring, reminder emails for users to renew their membership. Is there a way to set the date field to dynamically change each day to display the current date?

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

5 replies

Gerard_Donnell4
Level 9
February 12, 2018

Hi @Kerry Risley​,

Have you tried using this token {{system.date}}.

You can find for information here: System Tokens Glossary - Marketo Docs - Product Documentation

Thanks,

Gerard

Kerry_Risley
Level 1
February 12, 2018

Hi Gerard,

That is what I thought I could do, but it looks like I cannot put a token in for the date field. It requires a MM/DD/YYYY format.

Any other suggestions?

Thank you!

Kerry

Level 6
February 12, 2018

What about {{system.dateTime}}?

Level 6
February 12, 2018

Hi,

the {{system.date}} token returns the current date value. Maybe it can help.

Best;m

Valerie_Whitin2
Level 4
February 12, 2018

Hi @Kerry Risley​,

I don't think you can use tokens in smart lists, unfortunately :/ But you should be able to set the filter to "in time frame" "Today". Hopefully that helps!

Thanks,

Valerie

Gerard_Donnell4
Level 9
February 12, 2018

Hi @Kerry Risley​,

As @Valerie Whiting​ mentioned above adding the date constraint to your smart list filter should work.

Level 4
February 12, 2018

Hi @Kerry Risley,

As others have mentioned before, I would use {{system.dateTime}} to set the date in the flow. This will set the time stamp to have the exact date and time it was filled in.  

Then in the smart list, you have two options.  The easy way is to use the "in future: 24 hours" filter.  While this wont catch everyone that has a time stamp today, it will catch everyone within in next 24 hours.  So if you are automating an email that sends everyday at 9 am, this will have everyone who's time stamp is between 9 am today and 8:59 am tomorrow.

The other more complex way if you absolutely need to only email people that have today's date is to use both the "in future" and "in past" filters.  Keeping with the example above, if the email sends at 9 am daily, you can use "in future 15 hours" and "in past 9 hours" with advanced filter logic of (1 OR 2).  This gets tricky with time zones and has more room for error, but if its something you need, it can be done. Just remember to calculate the number of hours between 12 am and the email send time (in past) and the number of hours between email send time and 11:59 pm (in future).

Hope this helps!