topic How to Use Mid with Min Function in App Development

How to Use Mid with Min Function

Anonymous — Sun, 08 May 2016 11:34:20 GMT

Hello Everyone!

So I have this field which contains a code and within that code there is a year (e.g. XXYYYYZZZZZ, where YYYY represents the year).

So what I would like to do is to get the minimum year after extracting it from that field. I have tried the following:

Min(Mid(Code, 3, 4))

Min(aggr(Mid(Code, 3, 4), ID))

But it doesn't work.

Your help is appreciated.

Re: How to Use Mid with Min Function

marcus_sommer — Sun, 08 May 2016 14:07:24 GMT

With these informations it's quite difficult to say what didn't worked like expected. Maybe it's easier to extract this within the script:

Num(Mid(Code, 3, 4)) as CodeYear

Are the other code-parts not numeric you could also use: keepchar(Code, '0123456789'). And then should be a min() or a firstsortedvalue() expression within the charts simpler.

- Marcus

Re: How to Use Mid with Min Function

sunny_talwar — Sun, 08 May 2016 14:09:16 GMT

Where exactly are you trying to do this? In the script? In an expression may be like this

Min(Year(Date#(Mid(Code, 3, 4), 'YYYY')))

Re: How to Use Mid with Min Function

Anonymous — Mon, 09 May 2016 05:21:17 GMT

Sorry didn't work.