MAX YEAR

[gauthamchilled]

i have a listbox..

Year

FY2015

MY2015

FY2014

MY2014

I WANT TO CREATE A TRIGGER TO SELECT LATEST OR MAX FIELD FROM THIS LISTBOX..

HOW CAN I  CREATE AN EXPRESSION FOR SELECT IN FIELD TRIGGER TO SELECT MAX YEAR

[Chanty4u]

try this

Sum({$<Year={'2015'}>}[Sales Amount]) - expression works,

or

(Year={$(=Max(Year))})

[Chanty4u]

or u can give trigger

select infied  

Filedname:  date field name

String : =Max(date field)

[Chanty4u]

PFA

sample

[tresesco]

What are FY and MY stand for? Which is max year in your sample data?

[settu_periasamy]

Hi,

In the Trigger (May be Button Action / Text Action), Try this..

Select In Field

Field  :  Year

Search String :  ='*'&Max(Aggr(Right(Year,4),Year))

Edit

Instead of '*', Just give 'FY'

='FY'&Max(Aggr(Right(Year,4),Year))

[gauthamchilled]

NONE OF THE SOLUTION WORKED.  ATTACHED MY REQUIREMENT.. HELP PLZ

[gauthamchilled]

fy IS FULL YEAR

MY IS MID YEAR

[settu_periasamy]

Have you checked my attachment? If you need When the document open..

find the attachment

[Kushal_Chawda]

see this

check the OnOpen trigger