How to Create a Date or DateTime Format Tag in Campaigns
Intro
Change the format of your Date or DateTime field directly in Campaigns before delivering to your customers.
Formatting patterns examples
You can use pre-formatted strings to format your Date or DateTime fields however you want. Some examples of common patterns are:
| PATTERN | EXAMPLE |
yyyy-MM-dd |
2018-07-14 |
dd-MMM-yyyy |
14-Jul-2018 |
dd/MM/yyyy |
14/07/2018 |
E, MMM dd yyyy |
Sat, Jul 14 2018 |
h:mm a |
12:08 PM |
EEEE, MMM dd, yyyy HH:mm:ss a |
Saturday, Jul 14, 2018 14:31:06 PM |
yyyy-MM-dd'T'HH:mm:ssZ |
2018-07-14T14:31:30+0530 |
hh 'o''clock' a, zzzz |
12 o’clock PM, Pacific Daylight Time |
K:mm a, z |
0:08 PM, PDT |
Patterns for formatting
Here is a complete list of the symbols and meaning that can be used to format your Date and DateTime fields. Examples are given using the date August 3rd, 2020.
| SYMBOL | MEANING | PRESENTATION | EXAMPLES |
| yy, yyyy | The year. | year | 20, 2020 |
| M, MM, MMM, MMMM | The month of the year. | number/text | 8, 08, Aug, August |
| d, dd | The day of the month. | number | 3, 03 |
| E, EEEE, EEEEE | The day of the week. | text | Thu, Thursday, T |
| D | The day of year. The number of days since January 1st. | number | 216 |
| G, GGGG, GGGGG | The period or era. | text | AD, Anno Domini, A |
| h, hh | The hour, using a 12-hour clock from 1 to 12. | number | 6, 06 for single digit numbers OR 11, 11 for double digit numbers |
| H, HH | The hour, using a 24-hour clock from 0 to 23. | number | 6, 06 for single digit numbers OR 18, 18 for double digit numbers |
| K, KK | The hour, using a 12-hour clock from 0 to 11. | number | 6, 06 for single digit numbers OR 11, 11 for double digit numbers |
| k, kk | The hour, using a 24-hour clock from 1 to 24. | number | 6, 06 for single digit numbers OR 18, 18 for double digit numbers |
| m, mm | The minute, from 0 through 59. | number | 3, 03 for single digit numbers OR 13, 13 for double digit numbers |
| s, ss | The seconds of a minute, from 0 through 59. | number | 4, 04 for single digit numbers OR 11, 11 for double digit numbers |
| S, SS, SSS | The fractions of a second, from 0, through 999. | number | 9, 09, 009 |
| V, VVVV, VVVVV | Time Zone ID | zone-id | America/Los_Angeles; Z; -08:30 |
| z, zzzz | Time Zone Name | zone-name | Pacific Standard Time; PST |
| O, OOOO, OOOOO | Localized Zone Offset | offset-O | GMT+8; GMT+08:00; UTC-08:00; |
| X, XX, XXX, XXXX, XXXXX | Zone Offset 'Z' for zero | offset - X | Z; -08; -0830; -08:30; -083015; -08:30:15; |
| x, xx, xxx, xxxx, xxxxx | Zone Offset | offset - x | +0000; -08; -0830; -08:30; -083015; -08:30:15; |
| Z, ZZZZ, ZZZZZ | Zone Offset | offset - Z | +0000; -0800; -08:00; |
| ' | escape for text | delimiter | |
| '' | single quote (that is 2 single quotes, not a double-quote) | literal | ' |
Local Specific Formats
Below are some specific formatting examples based on local. Feel free to use them as a reference or a starting point when formatting your Date and DateTime fields.
ISO 8601 patterns
|
Date and time patterns |
Example |
|---|---|
|
yyyyMMddZ |
19990322+0100 |
|
yyyyMMdd |
19990322 |
|
yyyy-MM-dd G |
1999-03-22 AD |
|
yyyy-MM-ddXXX |
1999-03-22+01:00 |
|
yyyy-MM-dd'T'HH:mm:ss.SSS'['VV']' |
1999-03-22T05:06:07.000[Europe/Paris] |
|
yyyy-MM-dd'T'HH:mm:ss.SSS |
1999-03-22T05:06:07.000 |
|
yyyy-MM-dd'T'HH:mm:ss |
1999-03-22T05:06:07 |
|
yyyy-MM-dd'T'HH:mm:ss.SSS'Z' |
1999-03-22T05:06:07.000Z |
|
yyyy-MM-dd'T'HH:mm:ss.SSSXXX |
1999-03-22T05:06:07.000+01:00 |
|
yyyy-MM-dd'T'HH:mm:ssXXX |
1999-03-22T05:06:07+01:00 |
|
yyyy-DDDXXX |
1999-081+01:00 |
|
YYYY'W'wc |
1999W132 |
|
YYYY-'W'w-c |
1999-W13-2 |
|
yyyy-MM-dd'T'HH:mm:ss.SSSXXX'['VV']' |
1999-03-22T05:06:07.000+01:00[Europe/Paris] |
|
yyyy-MM-dd'T'HH:mm:ssXXX'['VV']' |
1999-03-22T05:06:07+01:00[Europe/Paris] |
Locale be: Belarussian
|
Date and time patterns |
Example |
|---|---|
|
d.M.yy |
22.3.99 |
|
d.M.yy H.mm |
22.3.99 5.06 |
|
d.M.yyyy H.mm.ss |
22.3.1999 5.06.07 |
Locale cs: Czech
|
Date and time patterns |
Example |
|---|---|
|
d.M.yyyy H:mm:ss |
22.3.1999 5:06:07 |
Locale da: Danish
|
Date and time patterns |
Example |
|---|---|
|
dd-MM-yy |
22-03-99 |
|
dd-MM-yy HH:mm |
22-03-99 05:06 |
|
dd-MM-yyyy HH:mm:ss |
22-03-1999 05:06:07 |
Locale de_DE: German, Germany
|
Date and time patterns |
Example |
|---|---|
|
dd.MM.yy |
22.03.99 |
|
d. MMMM yyyy |
22. März 1999 |
|
EEEE, d. MMMM yyyy |
Montag, 22. März 1999 |
|
dd.MM.yyyy |
22.03.1999 |
|
dd.MM.yy HH:mm |
22.03.99 05:06 |
|
d. MMMM yyyy HH:mm:ss z |
22. März 1999 05:06:07 MEZ |
|
dd.MM.yyyy HH:mm:ss |
22.03.1999 05:06:07 |
|
dd.MM.yy HH:mm:ss |
22.03.99 05:06:07 |
|
dd.MM.yyyy HH:mm |
22.03.1999 05:06 |
|
EEEE, d. MMMM yyyy HH:mm' Uhr 'z |
Montag, 22. März 1999 05:06 Uhr MEZ |
Locale en_CA: English, Canada
|
Date and time patterns |
Example |
|---|---|
|
d-MMM-yyyy |
22-Mar-1999 |
|
dd/MM/yy h:mm a |
22/03/99 5:06 AM |
|
EEEE, MMMM d, yyyy h:mm:ss 'o''clock' a z |
Monday, March 22, 1999 5:06:07 o'clock AM CET |
|
d-MMM-yyyy h:mm:ss a |
22-Mar-1999 5:06:07 AM |
Locale en_GB: English, United Kingdom
|
Date and time patterns |
Example |
|---|---|
|
dd MMMM yyyy |
22 March 1999 |
|
EEEE, d MMMM yyyy |
Monday, 22 March 1999 |
|
dd-MMM-yyyy |
22-Mar-1999 |
|
dd MMMM yyyy HH:mm:ss z |
22 March 1999 05:06:07 CET |
|
EEEE, d MMMM yyyy HH:mm:ss 'o''clock' z |
Monday, 22 March 1999 05:06:07 o'clock CET |
|
dd-MMM-yyyy HH:mm:ss |
22-Mar-1999 05:06:07 |
|
dd-MMM-yy hh.mm.ss.nnnnnnnnn a |
22-Mar-99 05.06.07.000000888 AM |
Locale en_US : English, United States
|
Date and time patterns |
Example |
|---|---|
|
M/d/yy |
3/22/99 |
|
MM/dd/yy |
03/11/22 |
|
MM-dd-yy |
03-22-99 |
|
M-d-yy |
3-22-99 |
|
MMM d, yyyy |
Mar 22, 1999 |
|
MMMM d, yyyy |
March 22, 1999 |
|
EEEE, MMMM d, yyyy |
Monday, March 22, 1999 |
|
MMM d yyyy |
Mar 22 1999 |
|
MMMM d yyyy |
March 22 1999 |
|
MM-dd-yyyy |
03-22-1999 |
|
M-d-yyyy |
3-22-1999 |
|
yyyy-MM-ddXXX |
1999-03-22+01:00 |
|
dd/MM/yyyy |
22/03/1999 |
|
d/M/yyyy |
22/3/1999 |
|
MM/dd/yyyy |
03/22/1999 |
|
M/d/yyyy |
3/22/1999 |
|
yyyy/M/d |
1999/3/22 |
|
M/d/yy h:mm a |
3/22/99 5:06 AM |
|
MM/dd/yy h:mm a |
03/22/99 5:06 AM |
|
MM-dd-yy h:mm a |
03-22-99 5:06 AM |
|
M-d-yy h:mm a |
3-22-99 5:06 AM |
|
MMM d, yyyy h:mm:ss a |
Mar 22, 1999 5:06:07 AM |
|
EEEE, MMMM d, yyyy h:mm:ss a z |
Monday, March 22, 1999 5:06:07 AM CET |
|
EEE MMM dd HH:mm:ss z yyyy |
Mon Mar 22 05:06:07 CET 1999 |
|
EEE, d MMM yyyy HH:mm:ss Z |
Mon, 22 Mar 1999 05:06:07 +0100 |
|
d MMM yyyy HH:mm:ss Z |
22 Mar 1999 05:06:07 +0100 |
|
MM-dd-yyyy h:mm:ss a |
03-22-1999 5:06:07 AM |
|
M-d-yyyy h:mm:ss a |
3-22-1999 5:06:07 AM |
|
yyyy-MM-dd h:mm:ss a |
1999-03-22 5:06:07 AM |
|
yyyy-M-d h:mm:ss a |
1999-3-22 5:06:07 AM |
|
yyyy-MM-dd HH:mm:ss.S |
1999-03-22 05:06:07.0 |
|
dd/MM/yyyy h:mm:ss a |
22/03/1999 5:06:07 AM |
|
d/M/yyyy h:mm:ss a |
22/3/1999 5:06:07 AM |
|
MM/dd/yyyy h:mm:ss a |
03/22/1999 5:06:07 AM |
|
M/d/yyyy h:mm:ss a |
3/22/1999 5:06:07 AM |
|
MM/dd/yy h:mm:ss a |
03/22/99 5:06:07 AM |
|
MM/dd/yy H:mm:ss |
03/22/99 5:06:07 |
|
M/d/yy H:mm:ss |
3/22/99 5:06:07 |
|
dd/MM/yyyy h:mm a |
22/03/1999 5:06 AM |
|
d/M/yyyy h:mm a |
22/3/1999 5:06 AM |
|
MM/dd/yyyy h:mm a |
03/22/1999 5:06 AM |
|
M/d/yyyy h:mm a |
3/22/1999 5:06 AM |
|
MM-dd-yy h:mm:ss a |
03-22-99 5:06:07 AM |
|
M-d-yy h:mm:ss a |
3-22-99 5:06:07 AM |
|
MM-dd-yyyy h:mm a |
03-22-1999 5:06 AM |
|
M-d-yyyy h:mm a |
3-22-1999 5:06 AM |
|
yyyy-MM-dd h:mm a |
1999-03-22 5:06 AM |
|
yyyy-M-d h:mm a |
1999-3-22 5:06 AM |
|
MMM.dd.yyyy |
Mar.22.1999 |
|
d/MMM/yyyy H:mm:ss Z |
22/Mar/1999 5:06:07 +0100 |
|
dd/MMM/yy h:mm a |
22/Mar/99 5:06 AM |
Locale es: Spanish
|
Date and time patterns |
Example |
|---|---|
|
d/MM/yy |
22/03/99 |
|
d/MM/yy H:mm |
22/03/99 5:06 |
|
d.M.yy H:mm |
22.3.99 5:06 |
Locale et: Estonian
|
Date and time patterns |
Example |
|---|---|
|
d.MM.yy |
22.03.99 |
|
d.MM.yyyy |
22.03.1999 |
|
d.MM.yy H:mm |
22.03.99 5:06 |
|
d.MM.yyyy H:mm:ss |
22.03.1999 5:06:07 |
Locale fi: Finnish
|
Date and time patterns |
Example |
|---|---|
|
d.M.yyyy |
22.3.1999 |
|
d.M.yyyy H:mm |
22.3.1999 5:06 |
Locale fr_CA: French, Canada
|
Date and time patterns |
Example |
|---|---|
|
yy-MM-dd |
99-03-22 |
|
yyyy-MM-dd |
1999-03-22 |
|
d MMMM yyyy HH:mm:ss z |
22 mars 1999 05:06:07 CET |
|
MMMM d, yyyy h:mm:ss z a |
March 22, 1999 5:06:07 CET AM |
|
yyyy-MM-dd HH:mm:ss |
1999-03-22 05:06:07 |
|
EEEE d MMMM yyyy H' h 'mm z |
lundi 22 mars 1999 5 h 06 CET |
Locale fr_FR: French, France
|
Date and time patterns |
Example |
|---|---|
|
dd/MM/yy |
22/03/99 |
|
d MMM yyyy |
22 mars 1999 |
|
d MMMM yyyy |
22 mars 1999 |
|
EEEE d MMMM yyyy |
lundi 22 mars 1999 |
|
dd/MM/yy HH:mm |
22/03/99 05:06 |
|
MM/dd/yy HH:mm |
03/22/99 05:06 |
|
M/d/yy HH:mm |
3/22/99 05:06 |
|
MM-dd-yy HH:mm |
03-22-99 05:06 |
|
M-d-yy HH:mm |
3-22-99 05:06 |
|
d MMM yyyy HH:mm:ss |
22 mars 1999 05:06:07 |
|
d MMMM yyyy HH:mm:ss z |
22 mars 1999 05:06:07 CET |
|
MM-dd-yyyy HH:mm:ss |
03-22-1999 05:06:07 |
|
M-d-yyyy HH:mm:ss |
3-22-1999 05:06:07 |
|
yyyy-M-d HH:mm:ss |
1999-3-22 05:06:07 |
|
dd/MM/yyyy HH:mm:ss |
22/03/1999 05:06:07 |
|
d/M/yyyy HH:mm:ss |
22/3/1999 05:06:07 |
|
MM/dd/yyyy HH:mm:ss |
03/22/1999 05:06:07 |
|
M/d/yyyy HH:mm:ss |
3/22/1999 05:06:07 |
|
EEEE d MMMM yyyy HH' h 'mm z |
lundi 22 mars 1999 05 h 06 CET |
|
dd/MM/yy HH:mm:ss |
22/03/99 05:06:07 |
|
MM/dd/yy HH:mm:ss |
03/22/99 05:06:07 |
|
M/d/yy HH:mm:ss |
3/22/99 05:06:07 |
|
dd/MM/yyyy HH:mm |
22/03/1999 05:06 |
|
d/M/yyyy HH:mm |
22/3/1999 05:06 |
|
MM/dd/yyyy HH:mm |
03/22/1999 05:06 |
|
M/d/yyyy HH:mm |
3/22/1999 05:06 |
|
MM-dd-yy HH:mm:ss |
03-22-99 05:06:07 |
|
M-d-yy HH:mm:ss |
3-22-99 05:06:07 |
|
MM-dd-yyyy HH:mm |
03-22-1999 05:06 |
|
M-d-yyyy HH:mm |
3-22-1999 05:06 |
|
yyyy-M-d HH:mm |
1999-3-22 05:06 |
Locale ga: Irish
|
Date and time patterns |
Example |
|---|---|
|
yy/MM/dd HH:mm |
99/03/22 05:06 |
Locale hr: Croatian
|
Date and time patterns |
Example |
|---|---|
|
yyyy.MM.dd |
1999.03.22 |
|
yyyy.MM.dd HH:mm:ss |
1999.03.22 05:06:07 |
|
yyyy.MM.dd HH:mm |
1999.03.22 05:06 |
Locale hu: Hungarian
|
Date and time patterns |
Example |
|---|---|
|
yyyy.MM.dd. |
1999.03.22. |
|
yyyy.MM.dd. H:mm:ss |
1999.03.22. 5:06:07 |
|
yyyy.MM.dd. H:mm |
1999.03.22. 5:06 |
Locale is: Icelandic
|
Date and time patterns |
Example |
|---|---|
|
d.M.yyyy HH:mm:ss |
22.3.1999 05:06:07 |
|
d.M.yyyy HH:mm |
22.3.1999 05:06 |
Locale it_IT: Italian, Italy
|
Date and time patterns |
Example |
|---|---|
|
d-MMM-yyyy |
22-mar-1999 |
|
dd/MM/yy H.mm |
22/03/99 5.06 |
|
yy-MM-dd HH:mm |
99-03-22 05:06 |
|
d-MMM-yyyy H.mm.ss |
22-mar-1999 5.06.07 |
|
d MMMM yyyy H.mm.ss z |
22 marzo 1999 5.06.07 CET |
|
EEEE d MMMM yyyy H.mm.ss z |
lunedì 22 marzo 1999 5.06.07 CET |
Locale iw: Hebrew
|
Date and time patterns |
Example |
|---|---|
|
HH:mm dd/MM/yy |
05:06 22/03/99 |
|
HH:mm:ss dd/MM/yyyy |
05:06:07 22/03/1999 |
Locale ja_JP: Japanese, Japan
|
Date and time patterns |
Example |
|---|---|
|
yy/MM/dd |
99/03/22 |
|
yyyy/MM/dd |
1999/03/22 |
|
yy/MM/dd H:mm |
99/03/22 5:06 |
|
MM/dd/yy H:mm |
03/22/99 5:06 |
|
M/d/yy H:mm |
3/22/99 5:06 |
|
MM-dd-yy H:mm |
03-22-99 5:06 |
|
M-d-yy H:mm |
3-22-99 5:06 AM |
|
MM-dd-yyyy H:mm:ss |
03-22-1999 5:06:07 |
|
M-d-yyyy H:mm:ss |
3-22-1999 5:06:07 |
|
yyyy-MM-dd H:mm:ss |
1999-03-22 5:06:07 |
|
yy/MM/dd H:mm:ss |
99/03/22 5:06:07 |
|
M/d/yy h:mm:ss a |
3/22/99 5:06:07 AM |
|
yyyy/MM/dd H:mm |
1999/03/22 5:06 |
|
dd/MM/yyyy H:mm |
22/03/1999 5:06 |
|
d/M/yyyy H:mm |
22/3/1999 5:06 |
|
MM/dd/yyyy H:mm |
03/22/1999 5:06 |
|
M/d/yyyy H:mm |
3/22/1999 5:06 |
|
MM-dd-yy H:mm:ss |
03-22-99 5:06:07 |
|
M-d-yy H:mm:ss |
3-22-99 5:06:07 |
|
MM-dd-yyyy H:mm |
03-22-1999 5:06 |
|
M-d-yyyy H:mm |
3-22-1999 5:06 |
|
yyyy-MM-dd H:mm |
1999-03-22 5:06 |
|
yyyy-M-d H:mm |
1999-3-22 5:06 |
Locale ko: Korean
|
Date and time patterns |
Example |
|---|---|
|
yy. M. d |
99. 3. 22 |
|
yyyy. M. d |
1999. 3. 22 |
Locale lt: Lithuanian
|
Date and time patterns |
Example |
|---|---|
|
yy.M.d |
99.3.22 |
|
yy.M.d HH.mm |
99.3.22 05.06 |
|
yyyy-MM-dd HH.mm.ss |
1999-03-22 05.06.07 |
Locale lv: Latvian
|
Date and time patterns |
Example |
|---|---|
|
yy.d.M |
99.22.3 |
|
yyyy.d.M |
1999.22.3 |
|
yy.d.M HH:mm |
99.22.3 05:06 |
|
yyyy.d.M HH:mm:ss |
1999.22.3 05:06:07 |
Locale mk: Macedonian
|
Date and time patterns |
Example |
|---|---|
|
d.M.yy HH:mm |
22.3.99 05:06 |
|
d.M.yyyy HH:mm: |
22.3.1999 05:06: |
Locale nl: Dutch
|
Date and time patterns |
Example |
|---|---|
|
d-M-yy |
22-3-99 |
|
d-M-yy H:mm |
22-3-99 5:06 |
Locale pt: Portuguese
|
Date and time patterns |
Example |
|---|---|
|
dd-MM-yyyy |
22-03-1999 |
|
dd-MM-yyyy H:mm |
22-03-1999 5:06 |
Locale ru: Russian
|
Date and time patterns |
Example |
|---|---|
|
dd.MM.yy H:mm |
22.03.99 5:06 |
|
dd.MM.yyyy H:mm:ss |
22.03.1999 5:06:07 |
Locale sq: Albanian
|
Date and time patterns |
Example |
|---|---|
|
yyyy-MM-dd h:mm:ss.a |
1999-03-22 5:06:07.PD |
|
yy-MM-dd h.mm.a |
99-03-22 5.06.PD |
|
yyyy-MM-dd h.mm.ss.a z |
1999-03-22 5.06.07.PD CET |
Locale sr: Serbian
|
Date and time patterns |
Example |
|---|---|
|
d.M.yy. |
22.3.99. |
|
dd.MM.yyyy. |
22.03.1999. |
|
d.M.yy. HH.mm |
22.3.99. 05.06 |
|
dd.MM.yyyy. HH.mm.ss |
22.03.1999. 05.06.07 |
|
dd.MM.yyyy. HH.mm.ss z |
22.03.1999. 05.06.07 CET |
Locale vi: Vietnamese
|
Date and time patterns |
Example |
|---|---|
|
HH:mm:ss dd-MM-yyyy |
05:06:07 22-03-1999 |
|
HH:mm dd/MM/yyyy |
05:06 22/03/1999 |
Locale zh_CN: Chinese (Simplified), China
|
Date and time patterns |
Example |
|---|---|
|
yy-M-d |
99-3-22 |
|
yyyy-M-d |
1999-3-22 |
|
yyyy'年'M'月'd'日' |
1999年3月22日 |
|
yyyy'年'M'月'd'日' EEEE |
1999年3月22日 星期一 |
|
yy-M-d ah:mm |
99-3-22 上午5:06 |
|
yyyy-M-d H:mm:ss |
1999-3-22 5:06:07 |
|
yyyy'年'M'月'd'日' ahh'时'mm'分'ss'秒' |
1999年3月22日 上午05时06分07秒 |
|
yyyy'年'M'月'd'日' H'時'mm'分'ss'秒' z |
1999年3月22日 5時06分07秒 CET |
|
yyyy'年'M'月'd'日' EEEE ahh'时'mm'分'ss'秒' z |
1999年3月22日 星期一 上午05时06分07秒 CET |