How to show min and max months /

[Anonymous]

I am using getfieldselection to show the months selected in the filter list. This shows all the months selected separated by comma.

Is it possible to show only the min and max months instead of showing all the months when multiple months are selected in the filter list?

[jonathandienst]

What's wrong with Min() and Max()? You might need to apply these to month-year values rather than month values, of course.

[Anonymous]

Is it possible to apply min and max to getfieldselection()?

[jonathandienst]

Why? Just use Min() and Max() on the month-year field. The functions respect the selections, so if you select a number of months, they will automatically adjust to the first and last selected months.

[florentina_doga]

use rank

min(data,1) return min data in selection

max(data,1) return max data in selection

[Anonymous]

Can you share an example using getfieldselections with max?

[tamilarasu · Accepted solution]

Hi Sanjyot,

Have a look at the attachment

=If(GetSelectedCount(Month)=1, 'Selected Month: ' & Num(Month),
If(GetSelectedCount(Month)>0,'Min Month: ' & Min(Month) & chr(13) & 'Max Month: ' & Max(Month)))

[Anil_Babu_Samineni]

This

GetFieldSelect(firstsortedvalue(Month, 'Month Min' & Min(Month),1))

[Anonymous]

This is working but doenst show the value in Jan 2013 but in digits like 4233 etc.. how do i convert this to month names?

[Anonymous]

I put date format and its working..used the below expression

if(GetSelectedCount(Month)=1,Month,if(GetSelectedCount(Month)>1,Min(date(Month,'MMM-YYYY')) & ' to ' & Max(date(Month,'MMM-YYYY'))))