Max date

[smilingjohn]

Hi All,

I have year field starting from from 200 7 onwards but in a list box i have to show it from 2016 onwards to do so

in a list box under expression i am writing like if(year >'2015',Year) . this is showing the correct results .i see year from 2016 to 2019 ,

I have a button which i am using to clear the selection. under actions i am writing like max(year) and when i am clicking on it this is not working (not selecting the 2019 year)
becuase in a list box i have not selected direct field values .
Can you expertise suggest me how do i sepcify this clear button , so that when i click on it it should make 2019 t get selected ?

Thanks in advance

[Arthur_Fong · Accepted solution]

Try this:

Under actions:

insert max({1}year)