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.