Altering date stamps

[Behalf_Marketin]

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_Keesom · Accepted solution]

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.