pastedImage_0.png

Smart List Operators for a Date Field

Marketo Employee
Marketo Employee

It is easy to get confused by all the different smart list operators when you use a date field in a smart list. Here is a summary of the operators and how to use them. The follower operators are based on using a date field and not a datetime type field.

pastedImage_0.png

When you filter based on whether the date is "in future", "in future after", "in past", or "in past after" you can use hours, days, weeks, months or years. For example, use in future 1 hour if you want the records which qualify today. If you use in future 2 days the smart list will include records from today, tomorrow and the next day. I have also tried using minutes which seemed to work.

Here is how to filter based in the future after 3 days time

pastedImage_8.png

  • A record will qualify if there is a date 4 or more days from now (e.g. the 4th day)
  • A record will qualify if there is a date 5, 6, 7, etc days from now.
  • If the date is 3 days away the record will not qualify
  • If the date is 1 or 2 days away the record will not qualify

Here is how to filter based in the past before 3 days time

pastedImage_12.png

  • A record will qualify if there is a date 4 or more days ago (e.g. the 4th day)
  • A record will qualify if there is a date 5, 6, 7, etc days ago.
  • If the date is 3 days in the past the record will not qualify
  • If the date is 1 or 2 days in the past the record will not qualify
1594
2
2 Comments

Thx Brian,

useful.

-Greg

Anonymous
Not applicable

Thanks Brian for documenting. Throw in in some NOT statements and that brings the confusion up a whole other level.