2 Replies Latest reply on Jun 1, 2017 11:57 AM by Frank Breen

    Date value changed options

    Nick Koutsioulis

      Hi all.

      I'm trying to create a series of lists populated by a smart campaign, based on the date that a data value has changed. I am having problems with the date, as i would like to add people to a list if the data value changed 7 days ago. I only have options in data value changed for 'past x days' or 'on or before x date'.  The problem is i dont want to add people who have changed in the last 7 days, and the date is constantly changing if this campaign runs each day.


      For example:

      Campaign 1

      - Data value 'step' changed to A 7 days ago

      - Add to List A


      Campaign 2

      - data value 'step' changed to A 21 days ago

      - Remove from List A

      - Add to List B


      if i use the 'between' option for date of activity, i need to enter a static date.


      Has anyone got any ideas how i can best do this? perhaps a my token velocity script to set 2 new date values, 7 days and 21 days, subtracting 7 (or 21) from the current date and using that in the between option?