Last 12 Months

building reports desktopintelligence
1

Hi - I am trying to flag last 12 months on a report and I created the variable below. It does work for Last 3Months or Last 6 Months but not for Last 12 Months (200911 - 200812 = 99). Is there a better way of doing this or any suggestions how I can change the expression below?

many thanks

=ToNumber(Left(FormatDate( ,“yyyymm”) ,6)) - ToNumber(FormatDate(ToDate(> ,“Mmm yyyy”) ,“yyyymm”))

BOaddictNYC (BOB member since 2003-07-11)

2

Please ignore. I was able to figure it out.

=MonthsBetween(ToDate( ,“Mmm yyyy”) ,)

BOaddictNYC (BOB member since 2003-07-11)