Help Center
Training
Knowledge Base
Community
Developers
Support

How to Create a Date or DateTime Format Tag in Campaigns

Domo University
  • Updated
Follow

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

Related articles

Comments

0 comments

Please sign in to leave a comment.