How to find latest year from 'YY/YY' format

[MZqlik]

Hi Everyone.
I have a field "financial year" which is in the following format: 21/22, 22/23 ('YY/YY').
I want to create a variable which identifies which one is the latest year (max) so that every year I don't have to update it manually. Does anybody have a clue if this can be done in this format or shall I covert the date format from the source data?
Thank you

Year field is literally:

'21/22'

'22/23'

[MZqlik]

Hi Everyone.
I have a field "financial year" which is in the following format: 21/22, 22/23 ('YY/YY').
I want to create a variable which identifies which one is the latest year (max) so that every year I don't have to update it manually. Does anybody have a clue if this can be done in this format or shall I covert the date format from the source data?
Thank you

[sidhiq91]

@MZqlik  Could you please provide us the sample data so that we can help you out?

[MZqlik]

I don't think there is much to share to be honest.

Year field is literally:

'21/22'

'22/23'

I would like to identify the latest with the set analysis. 

[MZqlik]

Apologies I meant to post this into Qlik Sense. I have just done it, feel free to remove this post. 

[Or · Accepted solution]

MaxString([Financial Year]) should work here. If your max year in the example above is '23', use Right(MaxString([Financial Year]),2).

[MZqlik]

Perfect that does the job. Thank you!