topic Re: using timestamps in QlikView https://community.qlik.com/t5/QlikView/using-timestamps/m-p/412306#M153479 <HTML><HEAD></HEAD><BODY><P>it worked, thanks</P><P>felipe</P></BODY></HTML> Thu, 10 Jan 2013 18:56:49 GMT felcar2013 2013-01-10T18:56:49Z using timestamps https://community.qlik.com/t5/QlikView/using-timestamps/m-p/412304#M153477 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have timestamps like this: </P><P>2013-01</P><P>2012-12</P><P>2012-11</P><P>2012-10</P><P>..........</P><P>2012-01</P><P>2011-12</P><P>2011-11</P><P>2011-10</P><P>.........</P><P>2011-01</P><P>2010-12</P><P>2010-11</P><P>2010-10</P><P>.......</P><P>2010-01</P><P>2009-12</P><P>etc.</P><P></P><P>I just want to show </P><P></P><P>2012-12 as 2012</P><P>2011-12 as 2011</P><P>2010-12 as 2010</P><P></P><P>how could i do this without complicating it?</P><P>thanks a lot, and sorry for disturbing,</P><P>felipe</P></BODY></HTML> Thu, 10 Jan 2013 18:22:23 GMT https://community.qlik.com/t5/QlikView/using-timestamps/m-p/412304#M153477 felcar2013 2013-01-10T18:22:23Z Re: using timestamps https://community.qlik.com/t5/QlikView/using-timestamps/m-p/412305#M153478 <HTML><HEAD></HEAD><BODY><P>Try</P><P></P><P>SubField(your_time_stamp_field,'-',1)</P></BODY></HTML> Thu, 10 Jan 2013 18:24:39 GMT https://community.qlik.com/t5/QlikView/using-timestamps/m-p/412305#M153478 nagaiank 2013-01-10T18:24:39Z Re: using timestamps https://community.qlik.com/t5/QlikView/using-timestamps/m-p/412306#M153479 <HTML><HEAD></HEAD><BODY><P>it worked, thanks</P><P>felipe</P></BODY></HTML> Thu, 10 Jan 2013 18:56:49 GMT https://community.qlik.com/t5/QlikView/using-timestamps/m-p/412306#M153479 felcar2013 2013-01-10T18:56:49Z