HOW TO SET DATE IN ALL CAPS FOR PRINTOUT REPORTS



Problem Scenario(s):

User’s requirement is to set the date in printouts as ALL CAPS.

 



Even using the Format String settings, there are no options to set the date (month) in ALL CAPS.


 


Resolution(s):

Create a calculated field



Right click in that field and select ‘Edit Expression’

 

 

 

In the expression, input the following codes: Upper(FormatString('{0:MMMddyy}',[Date]))




Click OK once done then replace the calculated field in the report designer




The month part of the date is now in ALL CAPS.