Max value in the list box

[manoranjan_d]

Hi,

In the list box of value

Apr16

May16

June16

Apr17

Jun17

i want to select the max value int he list box

i tried to giving the trigger as =max({1}Type_Period) but its not working and not picking the max value as Jun17

help me how to do this?

[sunny_talwar]

Then first step would be to fix that in the script

LOAD Date(Alt(Num(Date#(Type_Period,'MMMYY')), Num(Date#(Type_Period,'MMMMYY'))), 'MMMYY') AS Type_Period

and then trigger like this may be

Field

Type_Period

Search String

=Date(Max(Type_Period), 'MMMYY')

[vishsaggi]

It worked for me can you share your app you are trying on?