3 replies
by pcj1014 Accepted solution
by highab Accepted solution
by thumbsup2 Accepted solution
Excel stores the date internally as a 5 digit number representing how many days have passed since a certain date in the past (I forget what date that is). You can change how that date is formatted in Excel, but the formatting there doesn't change what is really stored internally.
To format a date in mail merge, you need to use the Date-Time Picture Switch. In Word, which is where the merge takes place, search Word Help for "Date-Time Picture Switch" or for "Format Merged Data".
For example, the switch \@ "dddd, MMMM d, yyyy" in the field { DATE \@ "dddd, MMMM d, yyyy" } displays "Friday, November 24, 2002." Combine the date and time instructions ? day (d), month (M), and year (y); hours (h) and minutes (m) ? to build a date-time picture. You can also include text, punctuation, and spaces.
This discussion is closed to new replies.
Trending Software posts
Sort by Trending