Tokens for date/time formatting

Year, month, and day tokens

Token Output Description
YY 70 71 ... 29 30 2 digit year
YYYY 1970 1971 ... 2029 2030 4 digit year
Y 1970 1971 ... 9999 +10000 +10001 Year with any number of digits and sign
Q 1 2 3 4 Quarter of year
Qo 1st 2nd 3rd 4th Quarter of year with ordinal
M 1 2 ... 11 12 Month number
Mo 1st 2nd ... 11th 12th Month with ordinal
MM 01 02 ... 11 12 Month number with leading zero
MMM Jan Feb ... Nov Dec Month abbreviation
MMMM January February ... November December Month name
D 1 2 ... 30 31 Day of month
Do 1st 2nd ... 30th 31st Day of month with ordinal
DD 01 02 ... 30 31 Day of month with leading zero
DDD 1 2 ... 364 365 Day of year
DDDo 1st 2nd ... 364th 365th Day of year with ordinal
DDDD 001 002 ... 364 365 Day of year with leading zero

Week year, week, and weekday tokens

Token Output Description
d 0 1 ... 5 6 Day of week
do 0th 1st ... 5th 6th Day of week with ordinal
dd Su Mo ... Fr Sa Day abbreviation
ddd Sun Mon ... Fri Sat Day abbreviation
dddd Sunday Monday ... Friday Saturday Day name
E 1 2 ... 6 7 Day of week (ISO)
w 1 2 ... 52 53 Week of year
wo 1st 2nd ... 52nd 53rd Week of year with ordinal
ww 01 02 ... 52 53 Week of year with leading zero
W 1 2 ... 52 53 Week of year (ISO)
Wo 1st 2nd ... 52nd 53rd Week of year with ordinal (ISO)
WW 01 02 ... 52 53 Week of year with leading zero (ISO)
gg 70 71 ... 29 30 Week year
gggg 1970 1971 ... 2029 2030 Week year
GG 70 71 ... 29 30 Week year (ISO)
GGGG 1970 1971 ... 2029 2030 Week year (ISO)

Hour, minute, second, millisecond, and offset tokens

Token Output Description
H 0 1 ... 22 23 24 hour time
HH 00 01 ... 22 23 24 hour time with leading zero
h 1 2 ... 11 12 12 hour time
hh 01 02 ... 11 12 12 hour time with leading zero
k 1 2 ... 23 24 24 hour time
kk 01 02 ... 23 24 24 hour time with leading zero
A AM PM Post or ante meridiem (upper case)
a am pm Post or ante meridiem (lower case)
m 0 1 ... 58 59 Minutes
mm 00 01 ... 58 59 Minutes with leading zero
s 0 1 ... 58 59 Seconds
ss 00 01 ... 58 59 Seconds with leading zero
S 0 1 ... 8 9 Fractional seconds
SS 00 01 ... 98 99 Fractional seconds with leading zero
SSS 000 001 ... 998 999 Fractional seconds with two leading zeros
SSSS ... SSSSSSSSS 000[0..] 001[0..] ... 998[0..] 999[0..] Fractional seconds
Z -07:00 -06:00 ... +06:00 +07:00 Time zone
ZZ -0700 -0600 ... +0600 +0700 Time zone
X 1360013296 Unix Timestamp
x 1360013296123 Unix Millisecond Timestamp

Popular use cases from our blog

automated-data-collection-crm-illustration

How to Automate Data Collection - Part 5: CRM Systems

automated-data-collection-chatbot-marketing-illustration

How to Automate Data Collection - Part 4: Chatbot Marketing

automated-data-collection-paid-ads-illustration

How to Automate Data Collection - Part 3: Paid Ads

automated-data-collection-email-illustration

How to Automate Data Collection - Part 2: Email Marketing Segmentation

personalized-customer-experience-illustration-integromat

5 Automated Solutions to Personalize Customer Experience

data-collection-automation-forms-pt-1

How to Automate Data Collection - Part 1: Online Forms

Didn’t find what you were looking for?

Ticket

Create a ticket

Contact our world-class support team and tell us what’s happening.

Create a ticket
Expert

Find an expert

We feature a network of 450+ certified partners across the globe who are ready to help

Find an expert

Automate any workflow in your business

Sign up for a free account today. No credit card required, no time limits on free plan.