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:
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