report2000
Technical User
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
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