Help needed with Max Date trigger

[#1]

Hi

I have the following data and I need to create a trigger that when the user selects a month, it selects on the close_date_cal2 field the max date for each of the client, but as you can see it is selecting two for 120 and I just need the one from January 23rd.

Again, I need to create it as a trigger on the selection of the month field.

Thanks and regards,

[MK_QSL]

may be FirstSortedValue can helpful !

[#3]

Thanks Manish. How do I implement it on the trigger/selection?

[#4]

I tried this and didnt work

[zarmoton]