Format Date ALL CAPS 2

[CHUDMAN]

OK here goes guys and gals,
I want to format a date from:
March 12, 2005 to MARCH 12,2005

I know it should be easy, but none of my attempts work.

Need it fast.



Chad L. Miller
Configuration Analyst
SEI/CMM level 3 certified

http://www.lockheedmartin.com

 

[synapsevampire]

Please post your software version when requesting help.

Is this an actual date field, or a string field containing a date?

I'll assume that it's a date field, so use:

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

-k

 

[lbass]

You could use:

ucase(totext({table.date},"MMMM dd, yyyy"))

-LB

 

[CHUDMAN]

you are all gods!!!!!! ty ty ty

oH YEAH i AM USING CRYSTAL REPORTS 10

Chad L. Miller
Configuration Analyst
SEI/CMM level 3 certified

http://www.lockheedmartin.com