topic Re: how to create yearname in QlikView https://community.qlik.com/t5/QlikView/how-to-create-yearname/m-p/700438#M252835 <HTML><HEAD></HEAD><BODY><P>=Year(Today()) &amp; '-' &amp; (Year(Today())+1)</P><P></P><P>Change Today() with your DateField</P></BODY></HTML> Wed, 18 Jun 2014 08:43:43 GMT MK_QSL 2014-06-18T08:43:43Z how to create yearname https://community.qlik.com/t5/QlikView/how-to-create-yearname/m-p/700437#M252834 <HTML><HEAD></HEAD><BODY><P>hi, </P><P> i need to create yearname field like 2014-2015,2013-2014 etc</P></BODY></HTML> Wed, 18 Jun 2014 08:39:58 GMT https://community.qlik.com/t5/QlikView/how-to-create-yearname/m-p/700437#M252834 2014-06-18T08:39:58Z Re: how to create yearname https://community.qlik.com/t5/QlikView/how-to-create-yearname/m-p/700438#M252835 <HTML><HEAD></HEAD><BODY><P>=Year(Today()) &amp; '-' &amp; (Year(Today())+1)</P><P></P><P>Change Today() with your DateField</P></BODY></HTML> Wed, 18 Jun 2014 08:43:43 GMT https://community.qlik.com/t5/QlikView/how-to-create-yearname/m-p/700438#M252835 MK_QSL 2014-06-18T08:43:43Z Re: how to create yearname https://community.qlik.com/t5/QlikView/how-to-create-yearname/m-p/700439#M252836 <HTML><HEAD></HEAD><BODY><P>Probably you are trying to get fiscal year. If so try like:</P><P></P><P>Load</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <STRONG>YearName</STRONG>(DateField, 0, 4) as yearName&nbsp;&nbsp;&nbsp; // 4- denotes first month of fiscal year.</P></BODY></HTML> Wed, 18 Jun 2014 08:44:14 GMT https://community.qlik.com/t5/QlikView/how-to-create-yearname/m-p/700439#M252836 tresB 2014-06-18T08:44:14Z