Writing Code
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Writing Code
Message Icon Topic: Date - Month - Uppercase Post Reply Post New Topic
Author Message
botete
Newbie
Newbie
Avatar

Joined: 16 Sep 2007
Location: United States
Online Status: Offline
Posts: 15
Quote botete Replybullet Topic: Date - Month - Uppercase
    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
 
IP IP Logged
jkwrpc
Senior Member
Senior Member


Joined: 19 Jun 2007
Location: United States
Online Status: Offline
Posts: 432
Quote jkwrpc Replybullet 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.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.