6 Replies Latest reply: Mar 29, 2016 4:57 AM by Sunny Talwar RSS

    Not select month and year can it display jan - mar 2016 ?

    PAUL YEO

      Hi All

       

       

      I have below expression , it will display Jan to Mar 2016 when i click on year = 2016 and month =3 :-

       

      ='Jan -  ' & date(makedate(max(year)-0,max({<Year={$(=max(year)-0)}>} Month)), 'MMM-YYYY') & ' ' & ''  &ColumnDim601& ' ' 

       

       

      May i know how to change it , when user not click on year and month , how to make it display Jan  to Mar 2016

       

       

      Now it display Jan - Dec 2016 is wrong.

       

       

      Paul