help with expression

[arusanah]

I Have two Charts A & Chart B

Two input Boxes FromDate & ToDate

Chart A : Dynamically Generated columns for current selection of FromDate & ToDate

=if( Date >= vFromDate and  Date <= vToDate,Month(Date)&' - ' &right(Year(Date),2))

my requirement is to have

Chart B: which should Generate columns for  previous year for same FromDate & ToDate selection

i tried this expression but doesnt work.

=if( Date >=date(num(MakeDate(year(vFromDate)-1,Month(vFromDate),Day(vFromDate)))) and  Date <=date(num(MakeDate(year(vToDate)-1,Month(vToDate),Day(vToDate)))),Month(Date)&' - ' &right(year(vFromDate),2))

pls help!!

[ramoncova06]

try with this

=if( Date >= addyears(vFromDate,-1),

and 

Date <= addyears(vToDate,-1) , TEXT(Date(Date, 'MM-YY'))

[arusanah]

=if( Date >= addyears(vFromDate,-1) And Date <= addyears(vToDate,-1) , TEXT(Date(Date, 'MM-YY')))

DOESNT WORK

[ramoncova06]

what is the date format of your variables ?

[arusanah]

sorry ramon,

It did work finally had  some conflict with hidden dates . so cleared them