This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
YEAR(MID(policy,13,2)),'YYYY' as [POLICY YEAR],
where Policy= DDCETHDGTEF1130034
I want the resultant to be 2013 and not 13
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
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
So there must be some logic to find out which Policies fall under which centenary.