Hi
I have created a report which shows last years sales and this years sales controlled by a date_to prompt.
However when I run up to previous month it keeps displaying including this month.
[FYS]>= IF (extract (month,?To_date?) in (01,02,03) )
THEN ((extract(year,?To_date?)-1)-1)
ELSE (extract(year,?To_date?)-1 )
Any pointers would be appreciated.
Sid
I have created a report which shows last years sales and this years sales controlled by a date_to prompt.
However when I run up to previous month it keeps displaying including this month.
[FYS]>= IF (extract (month,?To_date?) in (01,02,03) )
THEN ((extract(year,?To_date?)-1)-1)
ELSE (extract(year,?To_date?)-1 )
Any pointers would be appreciated.
Sid