To set Trigger on MAX YEAR

[abhaysingh]

i have created Fiscal Year (e.g. 2011-2012, 2012-2013, 2013-2014,2014-2015)  from Date

Year i have created from DATE is 2011,2012,2013,2014 ,

but when i am doing Max(Fiscal Year) it is giving me output 2014, but i need it should show 2014-2015 so that i can set a Trigger for max Year

[tresB]

It is better to use dual() for such cases in the script. Or, you can try something like:

=FirstSortedValue([Fiscal Year], -Date)    as the search string for trigger.

[abhaysingh]

thanks for your feedback but i want to set trigger for max year

it is not allowing me set max function on =FirstSortedValue([Fiscal Year], -Date)   , giving me error

[er_mohit]

try to use maxstring(Fiscal Year)

[#5]

Hi Abhay,

You need to use group by for FirstSortedValue function ..

[abhaysingh]

thanks its working