As earlier mentioned the approach from min/max worked generally for your request. It cuold be also combined and formatted, perhaps so: date(min(YOURDATE), 'MMM YYYY') & ' - ' & date(max(YOURDATE), 'MMM YYYY').
Also would be getfieldselections() work, if you pick your first and last item from result, perhaps so: subfield(getfieldselections(Month, '|', 12), '|', 1).
So, with a little manipulation, and accounting for the possibility that my users would select a single month, I came up with the following...
subfield(getfieldselections(CalendarMonthName, '|', 100), '|', 1)
&' - '
&subfield(getfieldselections(CalendarMonthName, '|', 100), '|', GetSelectedCount(CalendarMonthName)
Thank you Marcus, your assistance really got me where I needed to go.....
=GetFieldSelections(FieldName) will give me back what I select (as expected). It can be modified to provide more or less field selections
Returns a string with the current selections in a field.
ValueSep is the separator to be put between field values. The default is ', '.
Maxvalues is the maximum number of field values to be individually listed. When a larger number of values is selected the format 'x of y values' will be used instead. The default is 6.
getfieldselections ( Year )
getfieldselections ( Year, '; ' )
getfieldselections ( Year, '; ' , 10 )
What I am specifically looking for is: If a user were to select a range of "CalendarMonths", instead of either the chart showing all the months selected or '7 of 12', I would like to chart to render Jan 2013 - July 2013 (for example)