Business Tools Blog

This is a guest blog from Cybelle Simoneau a valued member of Zayo Bandwidth’s legal team.

I found this helpful info online in case you ever need it.  For a date to appear “normal”  you use    \@ “MMMM d, yyyy”

Formatting dates:

1. right click on the field name e.g. > - see pop-up menu.
2. click on the ‘Toggle Field Codes’ option - see field expand e.g. {
MERGEFIELD “Date” }
3. edit the field to include \@ “dd MMMM yy” e.g. { MERGEFIELD “Date” \@ “dd
MMMM yy” }
4. preview your mail merge - see date in the format 1 April 05.

Full stops or slashes can be included:

The rules are as follows:
dd - day as two numbers e.g. 01
d - single figures drop the zero e.g. 1.
dddd - day of the week e.g. Tuesday
ddd - day of the week in three letters e.g. Tue
MM - month as two figures e.g. 04
M - single figures drop the zero e.g. 4
MMMM - month in words e.g. April
MMM - month as three letters e.g. Apr
yy - year in two figures e.g. 05
yyyy - year in four figures e.g. 2005