topic Re: variable in QlikView https://community.qlik.com/t5/QlikView/variable/m-p/1227500#M391575 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Date(MonthStart(Today(), -1), 'YYYYMM')</STRONG></P></BODY></HTML> Fri, 03 Mar 2017 14:55:06 GMT sunny_talwar 2017-03-03T14:55:06Z variable https://community.qlik.com/t5/QlikView/variable/m-p/1227499#M391574 <HTML><HEAD></HEAD><BODY><P>Hello</P><P></P><P>I need to create a variable that retunrs the month -1 of today in that format yyyymm (201702)</P><P></P><P>LET vDate2 = date(Today(), 'YYYYMM') // this variable returns the current month and I need current month -1</P><P></P><P>Thanks</P></BODY></HTML> Fri, 03 Mar 2017 14:51:40 GMT https://community.qlik.com/t5/QlikView/variable/m-p/1227499#M391574 master_student 2017-03-03T14:51:40Z Re: variable https://community.qlik.com/t5/QlikView/variable/m-p/1227500#M391575 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>=Date(MonthStart(Today(), -1), 'YYYYMM')</STRONG></P></BODY></HTML> Fri, 03 Mar 2017 14:55:06 GMT https://community.qlik.com/t5/QlikView/variable/m-p/1227500#M391575 sunny_talwar 2017-03-03T14:55:06Z Re: variable https://community.qlik.com/t5/QlikView/variable/m-p/1227501#M391576 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny for your help</P></BODY></HTML> Fri, 03 Mar 2017 14:57:47 GMT https://community.qlik.com/t5/QlikView/variable/m-p/1227501#M391576 master_student 2017-03-03T14:57:47Z