How do you capitalize the month and day of a date?

[CBMC]

I am using CR8 and on my reports I have a print date.

The format of the reports require that the day and month be capitalized. Is there a way to print the date in the following form:

TUES., APR. 23, 2001

instead of the usual

Tues., Apr. 23, 2002


Thanks.

Also

 

[dgillz]

uppercase(totext(PrintDate,"dddd MMM dd, yyyy&quot)

or substitute any valid date field for PrintDate in the above formula and you should be Ok. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com