Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried this:
'='Jan - '&SubField('$(MonthNames)', ';', $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year)-1)'}>}month), Num(Month(Today())))))& ' ' & ' ' & (Max(year) - 1) & ' ' &ColumnDim51& ' '
my qvw
Have you tried this:
'='Jan - '&SubField('$(MonthNames)', ';', $(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year)-1)'}>}month), Num(Month(Today())))))& ' ' & ' ' & (Max(year) - 1) & ' ' &ColumnDim51& ' '
Hi sunny , okay i know i miss one bracket (