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
