Question on maxstring function

[#1]

Hi All, I have a text field OPENWEEK with the following values ('2013-1'.....upto '2013-45')

I am using a variable RaisedWK =maxstring(OPENWEEK) which returns '2013-9' as the maxvalue

How to tweak the maxstring function to get 2013-45 has the max value?

This is the expression which i am using in the straight table Count(if(OPENWEEK=RaisedWK,Number))

[Sokkorn]

Hi Basanth,

Do you have date field? If that, then we can try

RaisedWK=Only({$<[DateField]={$(=Max([DateField]))}>} [OPENDWEEK])

Regards,

Sokkorn