Altering date stamps | Community
Skip to main content
Behalf_Marketin
New Participant
November 11, 2021
Solved

Altering date stamps

  • November 11, 2021
  • 1 reply
  • 1284 views

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by Katja_Keesom

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.

1 reply

Katja_Keesom
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.