The following is a list of tokens you can use for valirous FunnelMerlin tricks. For most of them you create a token by using a percent sign (%) immediately following by a letter from below. Note for certain tricks, it allows for retrievivng more than one timezone by specifying a specific prefix character, and for those you use that character instead (ie. ~T instead of %T not %~T). Characters ARE case sensitive.
Token Letter | Description | Example values |
---|---|---|
Days | ||
d | Day of the month, 2 digits with leading zeros | 01 to 31 |
D | A textual representation of a day, three letters | Mon through Sun |
j | Day of the month without leading zeros | 1 to 31 |
l (lowercase 'L') | A full textual representation of the day of the week | Sunday through Saturday |
S | English ordinal suffix for the day of the month, 2 characters | st, nd, rd or th. Works well with j |
Months | ||
F | A full textual representation of a month, such as January or March | January through December |
m | Numeric representation of a month, with leading zeros | 01 through 12 |
M | A short textual representation of a month, three letters | Jan through Dec |
n | Numeric representation of a month, without leading zeros | 1 through 12 |
Years | ||
Y | A full numeric representation of a year, 4 digits | Examples: 1999 or 2003 |
y | A two digit representation of a year | Examples: 99 or 03 |
Time | ||
a | Lowercase Ante meridiem and Post meridiem | am or pm |
A | Uppercase Ante meridiem and Post meridiem | AM or PM |
g | 12-hour format of an hour without leading zeros | 1 through 12 |
G | 24-hour format of an hour without leading zeros | 0 through 23 |
h | 12-hour format of an hour with leading zeros | 01 through 12 |
H | 24-hour format of an hour with leading zeros | 00 through 23 |
i | Minutes with leading zeros | 00 to 59 |
s | Seconds, with leading zeros | 00 through 59 |
Timezones | ||
e | Timezone identifier | Examples: UTC, GMT, Atlantic/Azores |
T | Timezone abbreviation | Examples: EST, MDT ... |
If you happen to be familiar with PHP, you may notice that these come from PHP’s date formatting. We shortened the list to the main tokens for Date/Time display.