Expand my Community achievements bar.

The Community Ideas review for H1 2025 is out now, see which ideas our Product team prioritized and let us know your thoughts.

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