Expand my Community achievements bar.

Wondering how Workfront Proof works? Join our AMA on May 8th and ask our Community experts!

Mark Solution

This conversation has been locked due to inactivity. Please create a new post.

Change the Display format for Dates in Reports

Avatar

Level 4

11/1/19

Currently, without significant text edits, there is no way to change the way a date is displayed. By default dates are MM/DD/YY. I often have a need for a different date format that is either more report friendly (eg MMM-YYYY "Dec-2019" or DD-MMM-YYY "20-Dec-2019")


I have a workaround but it takes time and effort on from the report creator so it would be great if date formats could be modified with an inbuilt option.


Workaround Text edit for Report Column:

displayname=Custom Date

linkedname=direct

namekey=Original Due Date

querysort=DE:Original Due Date

textmode=true

valueexpression=IF(MONTH({DE:Original Due Date})="12",CONCAT("Dec-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="7",CONCAT("Jul-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="1",CONCAT("Jan-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="2",CONCAT("Feb-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="3",CONCAT("Mar-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="4",CONCAT("Apr-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="5",CONCAT("May-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="6",CONCAT("Jun-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="8",CONCAT("Aug-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="9",CONCAT("Sep-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="10",CONCAT("Oct-",YEAR({DE:Original Due Date})),IF(MONTH({DE:Original Due Date})="11",CONCAT("Nov-",YEAR({DE:Original Due Date})),"oops"))))))))))))

valuefield=Original Due Date

valueformat=HTML