topic Variable Syntax in QlikView https://community.qlik.com/t5/QlikView/Variable-Syntax/m-p/260478#M98268 <HTML><HEAD></HEAD><BODY><P>I need to create two variables. The first is the start month of my fiscal year and the second my fiscal year start month +12. I currently have the two below variables but the syntax is incorrect.</P><P>Any help would be greatly appreciated.</P><P></P><P></P><P>=date(monthstart(04-2011),'MM-YYYY') (This is titled vStartMonth)</P><P>=date(addmonths(vStartMonth,12),'MM-YYYY') (This is titled vFiscalYear)</P><P></P><P>Thanx</P></BODY></HTML> Thu, 02 Jun 2011 12:19:10 GMT 2011-06-02T12:19:10Z Variable Syntax https://community.qlik.com/t5/QlikView/Variable-Syntax/m-p/260478#M98268 <HTML><HEAD></HEAD><BODY><P>I need to create two variables. The first is the start month of my fiscal year and the second my fiscal year start month +12. I currently have the two below variables but the syntax is incorrect.</P><P>Any help would be greatly appreciated.</P><P></P><P></P><P>=date(monthstart(04-2011),'MM-YYYY') (This is titled vStartMonth)</P><P>=date(addmonths(vStartMonth,12),'MM-YYYY') (This is titled vFiscalYear)</P><P></P><P>Thanx</P></BODY></HTML> Thu, 02 Jun 2011 12:19:10 GMT https://community.qlik.com/t5/QlikView/Variable-Syntax/m-p/260478#M98268 2011-06-02T12:19:10Z Variable Syntax https://community.qlik.com/t5/QlikView/Variable-Syntax/m-p/260479#M98269 <HTML><HEAD></HEAD><BODY><P>Hi, you can write the first like this: </P><P>date(monthstart(date#('04-2011','MM-YYYY'))) (without the = on the variable definition)</P><P>date(addmonths(($(=vStartMonth)),12),'MM-YYYY') (for vFiscalYear, also without the <span class="lia-unicode-emoji" title=":grinning_face_with_big_eyes:">😃</span></P><P></P><P>When you need to include it in a text box, you can call it like this: </P><P>=$(=vFiscalYear)</P></BODY></HTML> Thu, 02 Jun 2011 12:29:22 GMT https://community.qlik.com/t5/QlikView/Variable-Syntax/m-p/260479#M98269 erichshiino 2011-06-02T12:29:22Z