How to make my title display from Jan - April 2020 [COMPANY] to 2020 [COMPANY]

[paulyeo11]

Hi All

Below expression Display "Jan - May 2020 [COMPANY]

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

May i know how to make it display 2020 [COMPANY]

i Have try below :-

='Jan - '&SubField('$(MonthNames)', ';', $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year)-0)'}>}month), )))& ' ' & ' ' & max(year) & ' ' &ColumnDim101& ' '

it does not work.

Paul

[edwin]

Im guessing the reason no ones responded to this is bec.  there isnt enough information to work on to even understand why your code is not working.  you are using a lot of columns and at least 1 variable that only you know what it contains.  adding a qvw would be most helpful to enable someone else to help you.