Format date and numeric fields
All of the date and numeric fields in the Merge Tool are assigned a default format. However, you can change this format to suit the needs of your property and your customer. For example, you may want the booking arrival date in your group contract to appear as "Saturday, May 12, 2025".
To format date and numeric fields
- Open the Word document.
- Log in to the Amadeus Merge Add-In Tool.
- Right-click the field you want to format and click Toggle Field Codes to display the field code.
- Enter the appropriate format switch after the merge field.
- For date fields, enter \@ as the format switch.
- For numeric fields, enter \# as the format switch.
- Insert the date or numeric format between quotation marks (see sections below).
- Right-click the field and click Update Field.
Date format strings begin with the \@ format switch and are followed by a combination of the following format components:
Example date format strings
Date format strings must be enclosed in quotation marks. For example, {MERGEFIELD nihrm__ArrivalDate__c\@ "dddd, MMMM d, yyyy"}. Copy and paste these commonly used strings into your template. When you toggle field codes, your cursor is exactly where you need to paste it (in between the c and the }).
\@ "dddd, MMMM d, yyyy" | Monday, January 12, 2025 |
\@ "ddd, M/dd/yy" | Mon, 1/12/25 |
\@ "dddd, MM/dd/yy" | Monday, 01/12/25 |
\@ "M/d/yy" | 1/12/25 |
\@ "MM/dd/yyyy" | 01/12/2025 |
\@ "MMM. dd, yy" | Jan. 12, 25 |
\@ "dddd dd MMMM yyyy" | Monday 12 January 2025 |
\@ "dd/MM/yyyy" | 12/01/2025 |
\@ "ddd, dd MMMM yyyy" | Mon, 12 January 2025 |
\@ "yyyy年M月d日" | 2025年1月12日 |
\@ "dd MMM yy" | 12 Jan 25 |
\@ "dddd, dd MMM yyyy" | Monday, 12 Jan 2025 |
Numeric format strings begin with the \# format switch and are followed by a combination of the following format components:
Example numeric format strings
Numeric format strings must be enclosed in quotation marks. For example, {MERGEFIELD nihrm__Rate__c\# "$#,###.00"}. Copy and paste these commonly used strings into your template. When you toggle field codes, your cursor is exactly where you need to paste it (in between the c and the }).
Locale | ||
\# "#,###" | 1,300 | |
\# "$#,###.00" | $12,195.35 | English |
\# "€#.###,##" | €12.195,35 | Dutch, German, Italian, Spanish |
\# "€# ###,00" | €12 195,35 | French |
\# "PLN###0.00" | PLN12195,67 | Polish |
The following is a list of some of the available format field switches for use in Microsoft Word. These are helpful when text or numbers need to be displayed in a specific manner; for example, when a currency amount needs to be spelled out as on a check, five hundred twenty one instead of 521.00.
\* Caps For example, { MERGEFIELD CONTACT_FULLNAME \* Caps } displays "Julie Tanner" even if the value is stored as lowercase letters (julie tanner). |
\* FirstCap Capitalizes the first letter of the first word. For example, { MERGEFIELD CONTACT_DESCRIPTION \* FirstCap } displays "Loves chocolate chip cookies." |
\* Upper Displays all letters in uppercase even if the value is stored as lowercase letters (julie tanner) or proper case (Julie Tanner). For example, { MERGEFIELD CONTACT_FULLNAME \* Upper } displays "JULIE TANNER." |
\* Lower displays all letters in lowercase. For example, { MERGEFIELD CONTACT_DESCRIPTION \* Lower } displays "loves chocolate chip cookies." |
These capitalization formats work in the same way for date formats also, for example, {MERGEFIELD nihrm__Booking__r.nihrm__ArrivalDate__c\@ "dddd, d MMMM, yyyy" \* FirstCap} will display the date as Monday, 12 January, 2020. |