Solved
Altering date stamps
Hello,
How can I write an equation to adjust a time stamp by 7 days?
For example, if someones subscription ends in one year on 11/11/21, the email should be sent 7 days prior on 11/4/21.
Thanks!
Katja_KeesomAccepted solution
Community Manager
November 11, 2021
The last thing I would do is actually alter the date stamp, as the consent still expires on the 11th.
You can schedule a daily batch campaign with two filters in your smart list:
- Subscription end date is in future 7 days AND
- Subscription end date is in future past 6 days
That should be a sure solution for the email to only be sent on the one specific day.