Question on maxstring function

Mon, 11 Nov 2013 07:52:10 GMT

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))

Re: Question on maxstring function

Sokkorn — Mon, 11 Nov 2013 07:56:54 GMT

Hi Basanth,

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

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

Regards,

Sokkorn