Message-ID: <1118863736.9945.1711707186888.JavaMail.web05$@web05> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_9944_1112204232.1711707186873" ------=_Part_9944_1112204232.1711707186873 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Field dialog opens when you add a new merge field to a template. To = open the dialog for an existing merge field, right-click the field and sele= ct Edit Field...
The following text formatting options can be set within Microsoft Word's= Field dialog, or by entering formatting codes within the merge field:
The Field Dialog in Microsoft Word 2002 (XP=
)
To set a merge field's formatting to Uppercase, Lowercase, Title case, o= r First capital using the Field dialog:
To display text before and/or after a merge field value:
You can also set these formatting options by entering special codes in t= he merge field. To view and edit a merge field's codes, right-click the fie= ld and select Toggle Field Codes. A field without special = formatting looks like this:
{MERGEFIELD FieldName}=20
Format |
Field Codes |
Example |
---|---|---|
Uppercase |
=20
{MERGEFIELD _FieldName_ \\* Upper}=20 |
=20
{MERGEFIELD ProductName \\* Upper}=20 |
Lowercase |
=20
{MERGEFIELD _FieldName_ \\* Lower}=20 |
=20
{MERGEFIELD ProductName \\* Lower}=20 |
First capital |
=20
{MERGEFIELD _FieldName_ \\* FirstCap}=20 |
=20
{MERGEFIELD ProductName \\* FirstCap}=20 |
Title case |
=20
{MERGEFIELD _FieldName_ \\* Caps}=20 |
=20
{MERGEFIELD ProductName \\* Caps}=20 |
Text Before |
=20
{MERGEFIELD _FieldName_ \b "_Text to insert before_"}<= /pre>=20 |
=20
{MERGEFIELD OrderDate \b "Order Date: "}=20 |
Text After |
=20
{MERGEFIELD _FieldName_ \f "_Text to insert after_"}= pre>=20 |
=20
{MERGEFIELD OrderDate \f " (Order Date)"}=20 |
Using field codes, you can apply date/time formatting to merge fields th= at will bind to database fields of types Date, Time, and Timestamp, or to a= n object of type System.DateTime. The general format for applying date/time= codes is:
{MERGEFIELD FieldName \@ "Formatting Pattern"}= =20
Date/Time Format Code |
Description |
Field Code Example |
Output Example |
---|---|---|---|
Day |
|||
d |
Displays the day of the month as a number. Si= ngle digit day numbers will not include a leading zero. |
=20
{MERGEFIELD Date \@ "M/d/yyyy"}=20 |
4/7/2003 |
dd |
Displays the day of the month as a number. Si= ngle digit day numbers will include a leading zero. |
=20
{MERGEFIELD Date \@ "dd MMMM yyyy"}=20 |
07 April 2003 |
ddd |
Displays a three-letter abbreviation for the = day of the week. |
=20
{MERGEFIELD Date \@ "ddd, d-MMM-yy"}=20 |
Mon, 7-Apr-03 |
dddd |
Displays the full name of the day of the week= . |
=20
{MERGEFIELD Date \@ "dddd, MMMM d, yyyy"}=20 |
Monday, April 7, 2003 |
Month (Use uppercase M for months, lowercase = m for minutes) |
|||
M |
Displays the month as a number. Single digit = month numbers will not include a leading zero. |
=20
{MERGEFIELD Date \@ "M/d/yy"}=20 |
4/7/03 |
MM |
Displays the month as a number. Single digit = month numbers will include a leading zero. |
=20
{MERGEFIELD Date \@ "yyyy-MM-dd"}=20 |
2003-O4-07 |
MMM |
Displays a three-letter month abbreviation.= p> |
=20
{MERGEFIELD Date \@ "MMM-yy"}=20 |
Apr-03 |
MMMM |
Displays the full month name |
=20
{MERGEFIELD Date \@ "MMMM d, yyyy"}=20 |
April 7, 2003 |
Year |
|||
yy |
Displays a two-digit year number. For years 1= -9, the year number will include a leading zero. |
=20
{MERGEFIELD Date \@ "MMM-yy"}=20 |
Apr-03 |
yyyy |
Displays a four digit year number |
=20
{MERGEFIELD Date \@ "MMMM d, yyyy"}=20 |
April 7, 2003 |
Hours |
|||
h |
Use lowercase h to display times based on the= 12-hour clock. Lowercase h displays single-digit hours as single-digit num= bers, without a leading zero. |
=20
{MERGEFIELD Time \@ "h:mm"}=20 |
6:05 |
hh |
Use lowercase hh to display times based on th= e 12-hour clock. Lowercase hh displays single-digit hours with a leading ze= ro. |
=20
{MERGEFIELD Time \@ "hh:mm am/pm"}=20 |
06:05 am |
H |
Use uppercase H to display times based on the= 24-hour clock. Uppercase H displays single-digit hours as single-digit num= bers, without a leading zero. |
=20
{MERGEFIELD Time \@ "H:mm"}=20 |
7:05 |
HH |
Use uppercase HH to display times based on th= e 24-hour clock. Uppercase HH displays single-digit hours with a leading ze= ro. |
=20
{MERGEFIELD Time \@ "HH:mm"}=20 |
18:30 |
Minutes (Use lowercase m for minutes, upperca= se M for months) |
|||
m |
Displays single-digit minutes without a leadi= ng zero. |
=20
{MERGEFIELD Time \@ "m 'minutes'"}=20 |
2 minutes |
mm |
Displays single-digit minutes with a leading = zero. |
=20
{MERGEFIELD Time \@ "hh:mm am/pm"}=20 |
06:05 am |
AM & PM |
|||
AM/PM |
Displays uppercase AM or PM. |
=20
{MERGEFIELD Time \@ "hh:mm AM/PM"}=20 |
08:30 PM |
am/pm |
Displays lowercase am or pm. |
=20
{MERGEFIELD Time \@ "hh:mm am/pm"}=20 |
07:55 am |
Other Text |
|||
'text' |
To display text within a date or time, enclos= e the text in single quotation marks. |
=20
{MERGEFIELD Date \@ "hh:mm 'EST'"}=20 |
06:15 EST |
character |
To include a character, such as - (hyphen), i= n a date or time, do not enclose in quotation marks. |
=20
{MERGEFIELD Date \@ "MMM-yy"}=20 |
Apr-03 |