How to get select max of year when already year selected

[Gopi_E]

Hi All,

I have field with year like

Year_New

2018

2019

2020

I need to select whenever i clicked on button i want max year select,so  i added action in button Actions select Field and value is =Max(Year_New), 

problem is, initially when i click on button max year selected, if i select 2018 in Year_New field then if i click on button then max year function is not performed.

Please give any solution on this,

Thanks in advance

@sunny_talwar please can you look into this

[Gopi_E · Accepted solution]

I got the solution

Max({1}Year_new)

Thank you

[Kushal_Chawda]

It's because you have used Max(Year) function. If you don't select anything it will return max year, if you select any year then it will consider that year as a max year, hence you need to exclude the selection of year field in trigger. Use max({1}Year)

[Gopi_E]

Thanks for the input kush,

yes, you are right, 

I got the idea and it works perfectly.