To add 2 days to the date in your mail merge field, you can use the following syntax:
- The "=" sign at the beginning tells Word that we're going to be using a formula.
- { Mergefield CourseDate } is the name of your merge field, which contains the original date from Access.
- "+ 2" adds two days to the original date.
- \@ "d" formats the result as a day of the month (e.g. "1", "2", "3", etc.).
- \* ordinal adds the appropriate suffix to the day (e.g. "st", "nd", "rd", or "th").
- { Mergefield CourseDate \@ "MMMM, yyyy" } adds the original date in the format "Month, Year".
So the end result will be a date that is
two days after the original date, displayed in the format "
Day Ordinal, Month Year".