Making a Date field on a report UPPERCASE

[angoni6]

Hello,
I have a report and on that report there is a Date field meant to show "Long Date" format (no problem on this). How can I make this field to show in UPPERCASE. Have tried =UCase([Your fields Here]) its giving me an error. How can I go about it. Am no expert in this.

 

[NauticalGent]

The format for date fields (Long Date, Short Date, etc) cannot be altered. You would have to make a custom format to do this.

 

[CJ_London]

try

=UCase(Format(Date(),"Long Date"))

 

[npatel]

Thank you for the TIP.