Uppercase Date Month 2

[glyph1]

Hello! I just had a (hopefully) simple question. Crystal Reports defaults the date to be lowercase and I need uppercase. I selected the format object and customize options and the formula, but I'm unsure how to distinguish the month as a string and convert it to uppercase. Any help would be greatly appreciated thank you!

 

[synapsevampire]

Use a formula of:

uppercase(totext({table.date},"MMMM"))

-k

 

[glyph1]

My current formula:
Day ({Visitor.SecurityDate})
& " "
& uppercase(totext({Visitor.SecurityDate},"MMMM"))
& " "
& Year ({Visitor.SecurityDate})

Produces an undesirable result:
1.00 SEPTEMBER 2,007.00

Probably an error on my part, I did turn off the decimal places and thousand seperator for the field properties.

 

[lbass]

Use:

totext(Day ({Visitor.SecurityDate}),0,"")
& " "
& uppercase(totext({Visitor.SecurityDate},"MMMM"))
& " "
& totext(Year ({Visitor.SecurityDate}),0,"")

-LB

 

[synapsevampire]

The 2 parameters LB uses are the number of decimals (0),and thousands seperator, "" meaning none.

You should post your entire requirements the first time or start new threads for other issues.

-k

 

[bdreed35]

You can simplify this formula to this to make it easier:

uppercase(totext({Visitor.SecurityDate},"d MMMM yyyy"))

~Brian