Hope you're having a great day!
I'm referencing a specific date DD/MM/YYYY (New Zealand date format) provided from Sales Cloud as part of an automated email journey for contacts experiencing product delays. This date is an estimated delivery date from a supplier. However, to help manage expectations and allow for delivery wiggle room, I would like to present the contact with a week commencing date derived from the provided date as below:
Data Extension: 15/06/2021
Email presents: "Our current best estimate is the week commencing Monday, June 14, 2021"
At present, I'm simply using the FormatDate function on the existing date without any logic to get the desired W/C date value. I've taken a look over the similar questions which arrived at answers making use of NOW() to get the current date but I was wondering if similar logic could be applied where the W/C date is calculated from a given future date.
The answers from Adam and Gortonington have certainly helped inspire the above with their answers to these questions:
- How can we generate the “day of year” or “week of year” in ampscript?
- Calculating the last day of next month using Ampscript
- Using AMPScript to output Current Month or following Month dependent on the day of the month in a Marketing Cloud Email
- Get first and last day of the week in Ampscript
Any help would be greatly appreciated.
