Formatting of MM/YYYY

[kutoose]

I need to format a field which is of format MM/YYYY to
MonthName YYYY.

For example, 11/2004 should be November 2004 like that !

CR Version : Crystal Reports 10

kutoose@yahoo.com

 

[lbass]

Try:

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

Or to keep it in date format, go to format field->date/time->customize->month: March->day: None->year: 1999.

-LB