Label now display Jan - Jul 2016 , How to make it display Jan - Jul 2015 ?

[paulyeo11]

Hi All

I have below expression working fine , it will display Jan - Jul 2016 :-

'='Jan - '&SubField('$(MonthNames)', ';',  $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year)-1)'}>}month), Num(Month(Today())))))& ' ' & ' ' & max(year) & ' '  &ColumnDim51& ' '

How to modify the above expression , so that label will display Jan - Jul 2015 ?

Paul

[paulyeo11]

my qvw

[sunny_talwar · Accepted solution]

Have you tried this:

'='Jan - '&SubField('$(MonthNames)', ';',  $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year)-1)'}>}month), Num(Month(Today())))))& ' ' & ' ' & (Max(year) - 1) & ' '  &ColumnDim51& ' '

[paulyeo11]

Hi sunny , okay i know i miss one bracket (