I am trying to create a formula that calulates the reporting month, but when i get to month 12 i get an error saying that there is no 13th month! The formula i am using is:

{Command.oppo_TargetClose} >= Cdate(2008,cdbl({?Report Month })+1,01)

(the parameter is set as a string.)

 

I know that i have to create a loop! to say when i get to month 13 then go to month 1 and add the new respective year to it  i.e jan 09.  otherwise just add 1 to the month.

 

Please help

If (cdbl({?Report Month}) = 12) then
  {command.oppo_TargetClose} >= Cdate(2009, 1, 1)
else
  {command.oppo_TargetClose} >= Cdate(2008, cdbl({?Report Month}) + 1, 01)

 

There are some other things you can do to dynamically set the year if you don't want to hard-code this report for this year.  It would look something like this:

if ({?Report Month}) = 12 then
  {Command.oppo_TargetClose} >= CDate(year(CurrentDate) + 1, 1, 1)
else
  {Command.oppo_TargetClose} >= CDate(year(CurrentDate), cdbl({?Report Month}) , 1)

 

-Dell