How to find the nth max fiscal quarter year in a list box using string function?

[rabbani_sk]

Hi All,

I have a Fiscal Quarter Year like below loaded in a improper sorting order , How to find the 2nd and 3rd  previous fiscal quarter years and also how to sort the order in the backend script.

FISCAL_QUATER_YEAR:

FYQ1 2018-19

FYQ3 2015-16

FYQ4 2015-16

FYQ1 2017-18

FYQ2 2017-18

[YoussefBelloum]

Hi,

you can use something like this (on the front-end sorting expression) :

=PurgeChar(mid(FISCAL_QUATER_YEAR,'6'),'-')

on the back-end you can use the same and add an order by ASC at the end of the load