topic Re: date in QlikView https://community.qlik.com/t5/QlikView/date/m-p/956352#M968379 <HTML><HEAD></HEAD><BODY><P>I am getting 1...</P><P>Let vTodaysDate = Num(MakeDate(Year(Today()),12,30));</P><P>Let vAdjustDate = $(vTodaysDate) - (MakeDate(2015,12,30)) + 1</P></BODY></HTML> Tue, 29 Sep 2015 08:21:27 GMT MK_QSL 2015-09-29T08:21:27Z date https://community.qlik.com/t5/QlikView/date/m-p/956350#M968377 <HTML><HEAD></HEAD><BODY><P>Thanks </P><P></P><P>Madhu</P></BODY></HTML> Tue, 29 Sep 2015 08:15:18 GMT https://community.qlik.com/t5/QlikView/date/m-p/956350#M968377 2015-09-29T08:15:18Z Re: date https://community.qlik.com/t5/QlikView/date/m-p/956351#M968378 <HTML><HEAD></HEAD><BODY><P>swap&nbsp; the variable and the expressions other way round</P></BODY></HTML> Tue, 29 Sep 2015 08:19:06 GMT https://community.qlik.com/t5/QlikView/date/m-p/956351#M968378 sasiparupudi1 2015-09-29T08:19:06Z Re: date https://community.qlik.com/t5/QlikView/date/m-p/956352#M968379 <HTML><HEAD></HEAD><BODY><P>I am getting 1...</P><P>Let vTodaysDate = Num(MakeDate(Year(Today()),12,30));</P><P>Let vAdjustDate = $(vTodaysDate) - (MakeDate(2015,12,30)) + 1</P></BODY></HTML> Tue, 29 Sep 2015 08:21:27 GMT https://community.qlik.com/t5/QlikView/date/m-p/956352#M968379 MK_QSL 2015-09-29T08:21:27Z Re: date https://community.qlik.com/t5/QlikView/date/m-p/956353#M968380 <HTML><HEAD></HEAD><BODY><P>One bracket is missing for today(). Try like:</P><P>Let vTodaysDate=Num(MakeDate(Year(Today<SPAN style="color: #ff0000;"><STRONG>(</STRONG></SPAN>)), 12,30);</P></BODY></HTML> Tue, 29 Sep 2015 08:22:40 GMT https://community.qlik.com/t5/QlikView/date/m-p/956353#M968380 tresB 2015-09-29T08:22:40Z Re: date https://community.qlik.com/t5/QlikView/date/m-p/956354#M968381 <HTML><HEAD></HEAD><BODY><P>Let vTodaysDate = Num(MakeDate(Year(Today()),12,30));</P><P>Let vAdjustDate = $(vTodaysDate) - (MakeDate(2015,12,30)) +1</P></BODY></HTML> Tue, 29 Sep 2015 08:26:56 GMT https://community.qlik.com/t5/QlikView/date/m-p/956354#M968381 sasiparupudi1 2015-09-29T08:26:56Z