Tokens for date and time parsing in Adobe Workfront Fusion

Access requirements

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

Adobe Workfront plan*
Pro or higher
Adobe Workfront license*
Plan, Work
Adobe 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 Adobe Workfront Plan, your organization must purchase Adobe Workfront Fusion as well as Adobe 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 Adobe Workfront Fusion as well as Adobe 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 Adobe Workfront Fusion licenses, see Adobe 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