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 |
Comments
0 comments
Please sign in to leave a comment.