ÃÛ¶¹ÊÓƵ

DocumentationWorkfrontWorkfront Guide

Tokens for date and time formatting in ÃÛ¶¹ÊÓƵ Workfront Fusion

Last update: Tue Jan 24 2023 00:00:00 GMT+0000 (Coordinated Universal Time)

CREATED FOR:

  • User

Access requirements

You must have the following access to use the functionality in this article:

ÃÛ¶¹ÊÓƵ Workfront plan*
Pro or higher
ÃÛ¶¹ÊÓƵ Workfront license*
Plan, Work
ÃÛ¶¹ÊÓƵ Workfront Fusion license**

Current license requirement: No Workfront Fusion license requirement.

Or

Legacy license requirement: Workfront Fusion for Work Automation and Integration

Product

Current product requirement: If you have the Select or Prime ÃÛ¶¹ÊÓƵ Workfront Plan, your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion as well as ÃÛ¶¹ÊÓƵ Workfront to use functionality described in this article. Workfront Fusion is included in the Ultimate Workfront plan.

Or

Legacy product requirement: Your organization must purchase ÃÛ¶¹ÊÓƵ Workfront Fusion as well as ÃÛ¶¹ÊÓƵ Workfront to use functionality described in this article.

To find out what plan, license type, or access you have, contact your Workfront administrator.

For information on ÃÛ¶¹ÊÓƵ Workfront Fusion licenses, see ÃÛ¶¹ÊÓƵ Workfront Fusion licenses.

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
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43