9 Replies Latest reply: Nov 28, 2013 3:57 AM by Sokkorn Cheav RSS

    How to make my year field return last 2 digit ?

      Hi All

       

       

      Now my year field as below :-

       

       

        year([date]) as [year],

       

       

      it generate 2009 2010 2011 2012

       

       

      How to make it display as 09 10 11 12 ?

       

       

      Now i am using below script at list box, which is not a good approach :-

       

       

      =

      IF(year='2014','14',

      IF(year='2013','13',

      IF(year= '1997' ,'97',

      IF(year= '1998' ,'98',

      IF(year= '1999' ,'99',

      IF(year= '2000' ,'00',

      IF(year= '2001' ,'01',

      IF(year= '2002' ,'02',

      IF(year= '2003' ,'03',

      IF(year= '2004' ,'04',

      IF(year= '2005' ,'05',

      IF(year= '2006' ,'06',

      IF(year= '2007' ,'07',

      IF(year= '2008' ,'08',

      IF(year= '2009' ,'09',

      IF(year= '2011' ,'11',

      IF(year= '2012' ,'12',

       

       

      IF(year= '2010','10'))))))))))))))))))

       

       

      Paul