Format dates in text mode reports

Dates can be configured to display in a variety of formats in reports and lists in Adobe Workfront. To establish a date format, you must modify the valueformat line of the text mode code in the column.

valueformat= [new date format] For example, if you wanted the Projected Completion Date to be displayed as MM/DD/YY the code would look like:

valueformat=atDate
valuefield=projectedCompletionDate

If you wanted to show the Planned Completion Date as Mth, DD, Year, the code would look like:

valueformat=mediumAtdate
valuefield=plannedCompletionDate

For more information about applying conditional formatting in Workfront reports and lists using text mode, see Use conditional formatting in Text Mode.

You can format dates using the following

valueformat

 text mode values:

Format Example  valueformat=
MM/DD/YY 10/11/18 atDate
MM/DD/YY Time 10/11/18 12:00pm longAtDate
MM/DD/YY 10/11/18 shortAtDate
Mth, DD, YR Oct, 11, 2018 mediumAtDate
DW, Mth, Day, YR Mon, Oct, 11, 2018 partialAtDate
DW, Mth, Day, YR Time Mon, Oct, 11, 2018 12:00 pm fullAtDate

On this page