topic YEAR and MID function together in QlikView

YEAR and MID function together

Anonymous — Thu, 07 Mar 2013 10:48:50 GMT

Hello,

YEAR(MID(policy,13,2)),'YYYY' as [POLICY YEAR],

where Policy= DDCETHDGTEF1130034

I want the resultant to be 2013 and not 13

Thu, 07 Mar 2013 11:01:36 GMT

Hi,

I'm not sure you can do that.

And, if you use a trick like this:

'20' & MID(policy,13,2) as [POLICY YEAR],

Hope it help

Regards

Giampiero

Anonymous — Thu, 07 Mar 2013 11:06:50 GMT

Hi Giampiero,

Yeah i thought so but your repsonse wouldnot work perfectly because most of the year are in 1900's and not only in 2000's

Thanks though.

somenathroy — Thu, 07 Mar 2013 11:10:18 GMT

So there must be some logic to find out which Policies fall under which centenary.

Regards,

som