How can you get the "month name" ?? 1

[alistairpaul]

I tried a couple different ways of doing "if month(table.datefield) = 1 then monthnamevar = "Jan", but I was unsuccessful.

Does anyone have a good way to do this?

Thanks!

 

[kenhamady]

if month(table.datefield) = 1 then "Jan" else
if month(table.datefield) = 2 then "Feb" else
if month(table.datefield) = 3 then "Mar" else ... Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[MalcolmW]

Or you can simply format the datefield to print just the month, either as "January", "Jan", "01", or "1". This works only for displaying the month portion, not as formula field for grouping by month. Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net

 

[kenhamady]

I assume you aren't using V8 which has a MonthName function. Ken Hamady

http://www.kenhamady.com/

Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)

 

[alistairpaul]

I got it - i used your Working Days formula as an example, Ken. it's working fine now.

thanks, all, for your help