Try something like this - note that is doesn't deal with All - for that (should you decide it is necessary), you would have to do something a bit more complicated <input type="multiselect" token="year">
<label>Year</label>
<fieldForLabel>year</fieldForLabel>
<fieldForValue>year</fieldForValue>
<search>
<query>| inputlookup supported_years.csv
| dedup year
| table year</query>
</search>
<default>2023</default>
<initialValue>2023</initialValue>
<change>
<eval token="earliest">mvindex(mvsort($form.year$),0)</eval>
<eval token="latest">mvindex(mvsort($form.year$),mvcount($form.year$)-1)</eval>
<eval token="timeRangeEarliest">strptime($earliest$."0101","%Y%m%d")</eval>
<eval token="timeRangeLatest">relative_time(strptime(($latest$)."0101","%Y%m%d"),"+1y")</eval>
</change>
</input>
... View more
