Print Page | Close Window

Date - Month - Uppercase

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Writing Code
Forum Discription: .NET programming API, report integration
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=1489
Printed Date: 03 May 2024 at 11:10am


Topic: Date - Month - Uppercase
Posted By: botete
Subject: Date - Month - Uppercase
Date Posted: 10 Oct 2007 at 8:07pm

Hi and Good Day!

I have a date field in my report, and it's in long format, I'd like the month to be printed in all uppercase form. Tried right-clicking and format the field but I can't seem to find the all uppercase form for the month. Please help. Thanks !
 
Bo Smile
 


Replies:
Posted By: jkwrpc
Date Posted: 16 Oct 2007 at 7:55am
There is a string function called "UpperCase' which you use in a formula.
 
From the CR Help file under 'String"
--------------------------------------------------------
Typical uses
A good use of this function is when a field contains both uppercase and lowercase letters and you want to convert all letters to uppercase for consistency.
Examples
The following examples are applicable to both Basic and Crystal syntax:
UpperCase("Description")
Returns "DESCRIPTION".
UpperCase({customer.FIRST NAME})
Returns "RONALD", where {customer.FIRST NAME} contains "Ronald".
UpperCase("Ronald Black")
Returns "RONALD BLACK".
UpperCase("abc12345")
Returns "ABC12345".
UpperCase("BrEaD "  + "AND "   +  "bUtTeR" )
Returns "BREAD AND BUTTER".
-------------------------------------
Hope this is what you are looking for.
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net


Print Page | Close Window