Month Names

[pricewc]

I've search but couldn't find what I was looking for. I currently have a report that shows the number of incidents reported per month. The months are shown because of this formula "Month({ALARMDATE})" they are shown in the report as 1, 2, 3, 4, etc....I would like the actual monrh names shown instead of the numbers and I need it to be in order. Is this possible? I just started using Crystal about a month ago. Thanks in advanced!

 

[fisheromacse]

it is early still for me, but maybe:
monthname(month({ALARMDATE}))

 

[pricewc]

That worked! But it put the months in order...April, August, February. How can I get it correct order?

thanks

 

[pricewc]

Sorry, I meant to say it put it in alphabetical order.

 

[IanWaterman]

Sort or group by

Month({ALARMDATE})

but display

monthname(Month({ALARMDATE}))

Ian

 

[pricewc]

Got it, thanks!

 

[lbass]

pricewc,

You are posting in the incorrect forum. In the future, try forum149 or forum767.

-LB