Integromat
  • Back to website
Articles in this section
  • Using Functions
  • Certificates and Keys
  • Math Variables
  • General Functions
  • String Functions
  • Math Functions
  • Date & Time Functions
  • Array Functions
  • Tokens for date/time formatting
  • Tokens for date/time parsing
  1. Integromat Support
  2. Using Integromat
  3. Functions

Tokens for date/time formatting

Patrik Šimek Patrik Šimek Updated January 22, 2021 12:22

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
Was this article helpful?
52 out of 65 found this helpful
Menu
  • Features
  • Apps & Services
  • Templates
  • Pricing
  • What's new
  • Use cases
Information
  • Terms,  Privacy
  • FAQ
  • Help & Tutorials
  • Community
  • Affiliate Program
  • Blog
Developers
  • Developer Platform
Company
  • About the company
  • Join our team
  • Contact
Follow us
© 2020 Integromat by Celonis. All rights reserved. Integromat® is a registered trademark.
  • English