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.
