topic Re: Date Variables in input box in QlikView https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032265#M348395 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P><STRONG>=Date(addmonths(Date#(v_Date, 'DD-MM-YYYY'),-1),'DD-MM-YYYY')</STRONG></P></BODY></HTML> Thu, 14 Apr 2016 09:10:53 GMT sunny_talwar 2016-04-14T09:10:53Z Date Variables in input box https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032264#M348394 <HTML><HEAD></HEAD><BODY><P>I have Variable v_Date 31-01-2015&nbsp;&nbsp; &amp; I want to show v_Date1&nbsp;&nbsp; as&nbsp; (v_date-30 days)</P><P>in input box .</P><P></P><P>Vikas</P></BODY></HTML> Thu, 14 Apr 2016 09:08:32 GMT https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032264#M348394 vikasmahajan 2016-04-14T09:08:32Z Re: Date Variables in input box https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032265#M348395 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P><STRONG>=Date(addmonths(Date#(v_Date, 'DD-MM-YYYY'),-1),'DD-MM-YYYY')</STRONG></P></BODY></HTML> Thu, 14 Apr 2016 09:10:53 GMT https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032265#M348395 sunny_talwar 2016-04-14T09:10:53Z Re: Date Variables in input box https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032266#M348396 <HTML><HEAD></HEAD><BODY><P>Or this for 30 days:</P><P></P><P><STRONG>=Date(Date#(v_Date, 'DD-MM-YYYY') - 30,'DD-MM-YYYY')</STRONG></P></BODY></HTML> Thu, 14 Apr 2016 09:12:54 GMT https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032266#M348396 sunny_talwar 2016-04-14T09:12:54Z Re: Date Variables in input box https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032267#M348397 <HTML><HEAD></HEAD><BODY><P>thnx</P></BODY></HTML> Thu, 14 Apr 2016 09:13:51 GMT https://community.qlik.com/t5/QlikView/Date-Variables-in-input-box/m-p/1032267#M348397 vikasmahajan 2016-04-14T09:13:51Z