ÃÛ¶¹ÊÓƵ

DocumentationWorkfrontWorkfront Guide

Tokens for date and time parsing 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

Input
Example
Description
YYYY
2014
4 or 2 digit year
YY
14
2 digit year
Y
-25
Year with any number of digits and sign
Q
1..4
Quarter of year. Sets month to first month in quarter.
M MM
1..12
Month number
MMM MMMM
Jan..December
Month name
D DD
1..31
Day of month
Do
1st..31st
Day of month with ordinal
DDD DDDD
1..365
Day of year
X
1410715640.579
Unix timestamp
x
1410715640579
Unix ms timestamp

Week year, week, and weekday tokens

Input
Example
Description
ddd dddd
Mon...Sunday
Day name
GGGG
2014
ISO 4 digit week year
GG
14
ISO 2 digit week year
W WW
1..53
ISO week of year
E
1..7
ISO day of week

Hour, minute, second, millisecond, and offset tokens

Input
Example
Description
H HH
0..23
Hours (24 hour time)
h hh
1..12
Hours (12 hour time used with a A.)
k kk
1..24
Hours (24 hour time from 1 to 24)
a A
am pm
Post or ante meridiem (Note the one character a p are also considered valid)
m mm
0..59
Minutes
s ss
0..59
Seconds
S SS SSS
0..999
Fractional seconds
Z ZZ
+12:00
Offset from UTC as +-HH:mm, +-HHmm, or Z
recommendation-more-help
5f00cc6b-2202-40d6-bcd0-3ee0c2316b43