Replacing a number with text 1

[greenman]

I am relatively new to SCR. I have part of my SQL query performing a datepart to convert the date to a number representing the month (1 - 12). In my report, I need the number to display as the full text of the month (eg- 1 = January). Thanks for any help!

 

[kenhamady]

If you have CR 8 there is the MonthName () function so that you can go:

MonthName ({number.field})

and get the name of the month.

Otherwise it is:

If {number.field} = 1 then "January" else
If {number.field} = 2 then "February" else
....
else December



Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training and a
Quick Reference Guide to VB/Crystal

 

[greenman]

Thanks! Worked perfectly. Apologies for neglecting to mention my version number (CR8).