Rolling Month Name with running total calculation 2

[report2000]

I am passing a date parameter to display three months rolling data.

I have the following formula:

For 3 Months Forward rolling (Assuming I am running for August 2008 parameter)

Left (MonthName (month({?Eff_Date})+1),3)
Left (MonthName (month({?Eff_Date})+2),3)
Left (MonthName (month({?Eff_Date})+3),3)
Formula shows only Sep, Oct, Nov, etc... no Year

AND

For 3 Months Backward rolling
Left (MonthName (month({?Eff_Date})-1),3)
Left (MonthName (month({?Eff_Date})-2),3)
Left (MonthName (month({?Eff_Date})-3),3)
Formula shows only Jul, Jun, May, etc... no Year

Formula shows only May, Apr, Mar, etc... no Year

Have two questions:
(1) I would like ot show the Month and Year (May 08, or Apr 08)
(2) When selecting Jan or Feb 2008 I get a error message saying the date should be beween 1 and 12. I guess somehow it gets a negative number

 

[dgillz]

Use the dateadd function

dateadd("m",-1,{?eff_date})

This will return an actual date. To get it to appear as MAR 08, just format it.

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

http://www.gainfocus.biz

"What version of URGENT!!! are you using?