Date and time formatting
In your document templates and email templates often date and time fields are used. You can customize the appearance of these date and time fields. For example, if you want to display a date as 22/08/2018 instead of 22 August 2018, you can do this.
A date field typically looks like «AppDate» (or something similar) in your templates. A time field typically looks like «AppTime» (or something similar). These fields are called merge fields.
Merge fields in document templates
To customize the appearance of a date or time field in your document templates, you need to update the merge field, add a backslash (\), immediately followed by the relevant code.
For example, by default «AppDate» formats to 22 August 2018, but «AppDate \dd/MM/yyyy» will format to 22/08/2018. This is achieved by the addition of \dd/MM/yyyy.
You can find more information on updating merge fields in document templates through the links below:
Managing document templates
Merge fields in Word for Mac
Merge fields in Word for Windows
Merge fields in email templates
To customize the appearance of date and time fields in your email templates (you can access it via Template Settings > Email templates), you simply need to add a backslash (\) followed by the relevant code in the merge field.
Codes that can be used
Code | Description |
d | Represents the day of the month as a number from 1 through 31. A single-digit day is formatted without a leading zero |
dd | Represents the day of the month as a number from 01 through 31. A single-digit day is formatted with a leading zero |
ddd | Represents the abbreviated name of the day of the week (Mon, Tues, Wed etc) |
dddd | Represents the full name of the day of the week (Monday, Tuesday etc) |
M | Month number |
MM | Month number with leading zero |
MMM | Abbreviated Month Name (e.g. Dec) |
MMMM | Full month name (e.g. December) |
yy | Year, leading zero (e.g. 2018 would be 18) |
yyyy | Year, (e.g. 2018 would be 2018) |
h | 12-hour clock hour (e.g. 7) |
hh | 12-hour clock, with a leading 0 (e.g. 07) |
H | 24-hour clock hour (e.g. 19) |
HH | 24-hour clock hour, with a leading 0 (e.g. 19) |
m | Minutes |
mm | Minutes with a leading zero |
tt | AM / PM (e.g. AM or PM) |
' | Represents a quoted string (apostrophe). Displays the literal value of any string between two apostrophe (') characters (e.g. 'de' will be formatted to de) |
Formatting of the codes and their appearance
Code formatting | Displayed as |
MM/dd/yyyy | 08/22/2018 |
dd/MM/yyyy | 22/08/2018 |
dd.MM.yyyy | 22.08.2018 |
dd-MM-yyyy | 22-08-2018 |
dd MMMM yyyy | 22 August 2018 |
MMMM dd, yyyy | August 22, 2018 |
dddd, dd MMMM yyyy | Wednesday, 22 August 2018 |
ddd, dd MMMM yyyy | Wed, 22 August 2018 |
ddd, dd MMM yyyy | Wed, 22 Aug 2018 |
ddd, dd MMM yyyy | Wed, 22 Aug 2018 |
HH:mm | 06:30 |
hh:mm tt | 06:30 AM |
H:mm | 6:30 |
h:mm tt | 6:30 AM |