List of all available date formats

List of all available date formats


Format
Output
Description
YY
23
Two-Digit Year
YYYY
2023
Four-Digit Year
M
1-12
The month, beginning at 1
MM
01-12
The month, 2-digit
MMM
Jan-Dec
The abbreviated month name
MMMM
January-December
The full month name
D
1-31
The day of the month
DD
01-31
The day of the month, 2-digits
d
0-6
The day of the week, with Sunday as 0
dd
Su-Sa
The min name of the day of the week
ddd
Sun-Sat
The short name of the day of the week
dddd
Sunday-Saturday
Then name of the day of the week
H
0-23
The hour
HH
00-23
The hour, 2-digit
h
1-12
The hour, 12-hour clock
hh
01-12
The hour, 12-hour clock, 2-digits
m
0-59
The minute
mm
00-59
The minute, 2-digits
s
0-59
The second
ss
00-59
The second, 2-digits
SSS
000-999
The millisecond, 3-digits
Z
+05:00
The offset from UTC, ±HH:mm
ZZ
+0500
The offset from UTC, ±HHmm
A
AM PM

a
am pm

Q
1-4
Quarter
Do 
1st 2nd ... 31st
Day of the Month with ordinal
k
1-24
The hour, beginning at 1
kk
01-24
The hour, 2-digit, beginning at 1
X
1360013296Unix Timestamp in second
XX
1360013296123
Unix Timestamp in millisecond
w
1 2 ... 52 53
Week of the year
ww
01 02 ... 52 53
Week of the year, 2-digit
W
1 2 ... 52 53
ISO Week of the year
WW
01 02 ... 52 53
ISO Week of the year, 2-digits
wo
1st 2nd ... 52nd 53rd
Week of the year with ordinal
gggg
2023
Week year (what year the week is in)
GGGG
2023
ISO Week Year (what ISO week the week is in)
z
EST
Abbreviated offset name (Timezone)
zzz
Eastern Standard Time
Unabbreviated offsent name (Timezone)


    • Related Articles

    • Write Text Pattern With Date Format

      Date Format templates and actions extend the standard "...write text pattern to column" and "...write text pattern to item name" by allowing you to specify a custom format for all dates. Action ...write text pattern to column with date format ...

    • Set Date from Date using Number

      Action ... set date to number days after date keeping time Use this action in the custom automation builder to create recipes. There are no pre-built automation templates for this action. Function Details Sets a date column in relation to another ...

    • Push Date Keeping Time

      Action ... push date by some days keeping the time Template Triggers When status changes to something... When date arrives push... Use actions in the custom automation builder to support additional triggers, and trigger conditions! Function Details ...

    • Write Text Pattern With Phone Format

      Phone format templates and actions format your phone numbers according to a specific format, such as the phone numbers national format, international format for the number, E.164 or RFC3966. Action ...write text pattern to column with phone format ...

    • Column Magic Automations

      Column Magic is a feature of automations that provides the individual automations in the app that are not part of a suite of templates. Automations Evaluate Expression to Column Push Date Keeping Time Set Date from Date using Number Expand Team to ...