Change the Display format for Dates in Reports

[#1]

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