3 Replies Latest reply: Jul 5, 2016 6:12 PM by Yeo Poh sai RSS

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

    Yeo Poh sai

      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