The default date format is mm/dd/yyyy. In order to change the format of a date token, use the token name followed by a pipe, then add the desired format and enclose it in brackets. (i.e. [orderDate|m/d/Y]).
Use the following key and examples below to customize data tokens. Formatting is case sensitive.
You can also use most special characters such as colon, hyphen, and forward slash.
Date Format Key
Character | Description | Examples |
|---|---|---|
Days | --- | --- |
d | Numeric day of the month with leading zeroes | 01, 31 |
j | Numeric day of the month without leading zeroes | 1, 31 |
S | Suffix corresponding to the day | st, nd, rd, th |
l (lowercase L) | Day of the week | Monday, Sunday |
Months | --- | --- |
m | Numeric month with leading zeroes | 01, 12 |
n | Numeric month without leading zeroes | 1, 12 |
M | Shorthand for a month | Jan, Dec |
F | Full month | January, December |
Years | --- | --- |
y | Shorthand for a year | 99, 03 |
Y | Full year | 1999, 2003 |
Time | --- | --- |
a | Lowercase am or pm | am, pm |
A | Uppercase AM or PM | AM, PM |
g | Hour (12 Hour format) | 1, 12 |
i | Minute | 00, 59 |
s | Second | 00, 59 |
T | Timezone | EST, MDT, +05 |
The examples below are common date and time formats. You are not restricted to the provided examples.
Examples
Desired Format | Token Format | Example |
|---|---|---|
mm/dd/yyyy (default) | m/d/Y | 01/15/2025 |
mm/dd/yyyy 00:00 AM | m/d/Y g:i A | 01/15/2025 10:30 AM |
Weekday, Month dth, yyyy | l, F jS, Y | Wednesday, January 15th, 2025 |
Mmm. dth yyyy | M. d Y | Jan. 15th 2025 |
dd-mm-yy | d-m-y | 15-01-25 |