Date value changed options
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?