topic Re: Year format conversion in QlikView https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668591#M1062215 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply. It works</P></BODY></HTML> Tue, 23 Sep 2014 08:05:18 GMT Anonymous 2014-09-23T08:05:18Z Year format conversion https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668588#M1062212 <HTML><HEAD></HEAD><BODY><P>Hi, can anyone tell me how to convert a year from YYYY to YY.</P></BODY></HTML> Tue, 23 Sep 2014 07:09:33 GMT https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668588#M1062212 Anonymous 2014-09-23T07:09:33Z Re: Year format conversion https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668589#M1062213 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try</P><P></P><P>Right(Year,2) as NewYear</P><P>or</P><P>=date(today(),'YY')</P><P></P><P></P><P></P><P>regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 23 Sep 2014 07:12:23 GMT https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668589#M1062213 ashfaq_haseeb 2014-09-23T07:12:23Z Re: Year format conversion https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668590#M1062214 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try like:</P><P></P><P>Date(Year(filed),'YY');</P></BODY></HTML> Tue, 23 Sep 2014 07:14:51 GMT https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668590#M1062214 avinashelite 2014-09-23T07:14:51Z Re: Year format conversion https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668591#M1062215 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply. It works</P></BODY></HTML> Tue, 23 Sep 2014 08:05:18 GMT https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668591#M1062215 Anonymous 2014-09-23T08:05:18Z Re: Year format conversion https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668592#M1062216 <HTML><HEAD></HEAD><BODY><P>welcome <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 23 Sep 2014 08:07:14 GMT https://community.qlik.com/t5/QlikView/Year-format-conversion/m-p/668592#M1062216 ashfaq_haseeb 2014-09-23T08:07:14Z