Format dates in text mode reports

Last update: January 16, 2025

CREATED FOR:

  • User

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:

FormatExamplevalueformat=
MM/DD/YY10/11/18atDate
MM/DD/YY Time10/11/18 12:00pmlongAtDate
MM/DD/YY10/11/18shortAtDate
Mth, DD, YROct, 11, 2018mediumAtDate
DW, Mth, Day, YRMon, Oct, 11, 2018partialAtDate
DW, Mth, Day, YR TimeMon, Oct, 11, 2018 12:00 pmfullAtDate
Previous pageUse conditional formatting in Text Mode
Next pageFormat numbers, currency and percentage values in text mode reports

Workfront