Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Change the Display format for Dates in Reports

Avatar

Level 4

01-11-2019

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