Need to get Max week

[SatyaPaleti]

Hi Friends,

I am having following Data it shows all the weeks in 2015. I want to show max week among that

I am using Max function but it's not working

Here is the attachment & Qvw

Thank you,

Satya

[robert_mika]

Your data are in String format try

Max(right(Yourfield,2))

(no attachment just screen dump attached)

[tresesco]

Max() won't work here, because your field is a text one. Try MaxString().

[Anonymous]

try sth like at script level:

=mid(Week,6,7) as Week

and then at UI level like: max(week) or max(mid(Week,6,7))

[SatyaPaleti]

Here in My Data Max week is 2015-45

How to get that

[Anonymous]

Try this one :

max(mid(Week,6,7))

[Anonymous]

If it is into string then:

=max(mid(num(Week),6,7))