Date format in formula 2

[HezMac]

Hi

I would like a column heading to read: April - 2005

Where the year is dependant on the parameter entered.

I'm using the following formula:

If month({?StartDate}) in 4 to 12 then
   'April - ' & Year({?StartDate})
Else If month({?StartDate}) in 1 to 3 then
    'April - ' & Year({?StartDate}) -1

And getting a result of 'April - 2,005.00

I'm using CR 8.5 - do you know how I can format the number to be '2005'

Thanks

 

[dgillz]

Try this:

'April - ' & totext(Year({?StartDate}),0,"")

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[kskid]

Try this

If month({?StartDate}) in 4 to 12 then
   'April - ' & totext(Year({?StartDate}))
Else If month({?StartDate}) in 1 to 3 then
    'April - ' & totext(Year({?StartDate}) -1)

 

[HezMac]

Thanks, dgillz!
That worked!
What is that '0, "") ' anyway?

 

[dgillz]

0 = # of decimals
"" is the thousands separator

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz