Formatting Your Data
Here is a list of available modifiers. These modifiers are added along with the tokens(merge field).
Modifier | Description | Example |
Uppercase | Convert all characters to uppercase | {{upper company_name}} |
Lowercase | Convert all characters to lowercase | {{lower client.name}} |
Capitalize | Capitalize the first letter | {{capitalize client_name}} |
Format Date/Time | Convert date and time to a specific format | {{format_date _date 'DD-MM-YY'}} |
Format Number | Change the format of a number (thousands and decimals) | {{format_number number "." "," "3"}} |
Abbreviation | Convert text to abbreviation (First letter of each word in caps) | {{abbreviate name "."}} |
Syntax - {{format_date token_name "format" "language" "add/subtract time"}}
The default language is English(United States).
Example | Input | Output |
{{format_date _date 'DD-MM-YY'}} | 2019-05-25 | 25-05-19 |
{{format_date _date "MMMM DD YYYY" "fr"}} | 2019-05-25 | mai 25 2019 |
{{format_date _date "MMMM DD YYYY" "en" "+1years"}} | 2019-08-20 | August 20 2020 |
Example | Output |
DD-MM-YY | 21-11-18 |
ddd MMM DD HH:mm:ss | Wed Nov 21 14:08:25 |
MMMM DD YYYY HH:mm:ss | November 21 2018 14:08:25 |
MMMM DD YYYY | November 21 2018 |
MMM DD YYYY | Nov 21 2018 |
YYYY-MM-DD | 2018-11-21 |
MM-DD-YYYY | 01-22-2006 |
MM/DD/YYYY | 01/22/2006 |
MM/DD/YY | 01/22/06 |
DD-MM-YYYY | 22-01-2006 |
DD/MM/YYYY | 22/01/2006 |
DD/MM/YY | 22/01/06 |
X | 1542758400 |
​ | Token | Output |
Year | YYYY | 2000, 2001, 2002 ... 2012, 2013 |
​ | YY | 00, 01, 02 ... 12, 13 |
Month | MMMM | January, February, March ... |
​ | MMM | Jan, Feb, Mar ... |
​ | MM | 01, 02, 03 ... 11, 12 |
​ | M | 1, 2, 3 ... 11, 12 |
Day of Year | DDDD | 001, 002, 003 ... 364, 365 |
​ | DDD | 1, 2, 3 ... 364, 365 |
Day of Month | DD | 01, 02, 03 ... 30, 31 |
​ | D | 1, 2, 3 ... 30, 31 |
Day of Week | dddd | Monday, Tuesday, Wednesday ... |
​ | ddd | Mon, Tue, Wed ... |
​ | d | 1, 2, 3 ... 6, 7 |
Hour | HH | 00, 01, 02 ... 23, 24 |
​ | H | 0, 1, 2 ... 23, 24 |
​ | hh | 01, 02, 03 ... 11, 12 |
​ | h | 1, 2, 3 ... 11, 12 |
AM / PM | A | AM, PM |
​ | a | am, pm |
Minute | mm | 00, 01, 02 ... 58, 59 |
​ | m | 0, 1, 2 ... 58, 59 |
Second | ss | 00, 01, 02 ... 58, 59 |
​ | s | 0, 1, 2 ... 58, 59 |
Sub-second | SSS | 000, 001, 002 ... 998, 999 |
​ | SS | 00, 01, 02 ... 98, 99 |
​ | S | 0, 1, 2 ... 8, 9 |
Timestamp | X | 1381685817 |
Language code | Language & Country |
en-au | English (Australia) |
en-ca | English (Canada) |
en-ie | English (Ireland) |
en-il | English (Israel) |
en-nz | English (New Zealand) |
en-gb | English (United Kingdom) |
fr | French |
fr-ca | French (Canada) |
fr-ch | French (Switzerland) |
de | German |
de-at | German (Austria) |
de-ch | German (Switzerland) |
hu | Hungarian |
pt | Portuguese |
To adjust a date/time by a specific amount, you need to supply <+/-> <amount as a number> <unit>. Unit can be "years", "months", "weeks", "days", "hours", "minutes", or "seconds". Here are some examples:
+1hours-3days+5years+2months-3minutes+8h
Example | Input | Output |
{{format_date _date "MMMM DD YYYY" "en" "+1years"}} | 2019-08-20 | August 20 2020 |
{{format_date _date "MMMM DD, YYYY" "en" "+6months"}} | 2019-08-20 | February 20, 2020 |
Syntax - {{format_number number1 thousand_sep decimal_sep decimal_places}}
Example | Input | Output |
{{format_number number1 "." "," "0"}} | 123456 | 12.345 |
{{format_number number1 "." "," "3"}} | 12345.12345 | 12.345,123 |
Syntax - {{abbreviate name suffix}}, Suffix is not mandatory.
Example | Input | Output |
{{abbreviate name}} | John Doe | JD |
{{abbreviate name "."}} | John Doe | J.D |