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

[paulyeo11]

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

[sunny_talwar]

This:

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

[paulyeo11]

Hi sunny

Beautiful it work fine.

Thank

Paul

[paulyeo11]

Hi sunny

why i cannot mark as correct answer ? only can mark as helpful ?

Paul

[sunny_talwar]

Because this thread is a discussion thread and not a question thread. It can only be changed within the first 15 minutes from a discussion to question or question to discussion. I don't think you can change it now

[paulyeo11]

Hi sunny

i just notice that there it discussion and question. okay next time i take note , make sure it is question .

Paul

[sunny_talwar]

No problem