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:

Any help would be greatly appreciated.

1 Answer 1


I was going to suggest the same approach as the one in this post you linked. Just switch out NOW() for your delivery date.

  • Baneen! Hey. I was hoping it would be that simple, I swapped that out for the dynamic date and kept hitting validation issues. Possibly just a data issue. Will take another look at it again this afternoon. Great to hear from you, btw! :) Commented Jun 14, 2021 at 3:47
  • Likewise, nice to see you're still using Marketing Cloud, hope you're enjoying it! Probably is some kind of data issue, were the error messages very descriptive? Commented Jun 15, 2021 at 4:16
  • Descriptive? Never :p Commented Jun 16, 2021 at 0:30

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .