3 Replies Latest reply: Mar 7, 2013 6:10 AM by Some Nath Roy RSS

    YEAR and MID function together

    Adotey Kwame

      Hello,

       

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

       

      where Policy= DDCETHDGTEF1130034

       

      I want the resultant to be 2013 and not 13