To get the last record from a list

[Anonymous]

I have a listbox name Quarter with values Q1,Q2,Q3,Q4. I can use the GetFieldSelections(Quarter) to get the field selections for Quarter. However I need to find the last selected value. For Example if the user selected Q1,Q2,Q3 , the result should give me Q3 . How do I achieve this ?

[Anil_Babu_Samineni · Accepted solution]

May be use =MaxString(Quarter)

[devarasu07]

Hi,

Yes Anil Suggested maxstring function should work and u can get the desired result using text box object.

check below article from Robert Mika

How to use - MaxString & MinString

[Anonymous]

Thanks guys!!!.. This is what I needed!!