topic Re: calender in QlikView https://community.qlik.com/t5/QlikView/calender/m-p/749000#M267278 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>System Date: <STRONG>Today()</STRONG> function.</P><P></P><P>Substracting days depends on how you have your date stored.</P><P></P><P><STRONG>Today()-1</STRONG></P><P></P><P>gives you yesterday's date</P><P></P><P>In a textbox, write</P><P></P><P><STRONG>='Today: '&amp;today()&amp;'&nbsp; Yesterday: '&amp;date(today()-1)</STRONG></P><P></P><P>It'll show you today's and yesterday's dates.</P><P></P><P>It works in the same way in the script:</P><P></P><P>Load .....</P><P>&nbsp;&nbsp;&nbsp;&nbsp; today()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as SystemDate,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; today()-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as YesterdayDate</P><P>....</P><P></P><P>Regards,</P><P>Sorin.</P></BODY></HTML> Wed, 07 Jan 2015 16:38:26 GMT isorinrusu 2015-01-07T16:38:26Z calender https://community.qlik.com/t5/QlikView/calender/m-p/748998#M267276 <HTML><HEAD></HEAD><BODY><P>How to get the current system date in calender?</P><P>And how to subtract days from date?</P></BODY></HTML> Wed, 07 Jan 2015 16:26:03 GMT https://community.qlik.com/t5/QlikView/calender/m-p/748998#M267276 2015-01-07T16:26:03Z Re: calender https://community.qlik.com/t5/QlikView/calender/m-p/748999#M267277 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>please see this...</P><P></P><P><A href="https://community.qlik.com/thread/48693">Creating A Master Calendar</A></P><P></P><P>Regards</P><P></P><P>André Gomes</P></BODY></HTML> Wed, 07 Jan 2015 16:35:31 GMT https://community.qlik.com/t5/QlikView/calender/m-p/748999#M267277 agomes1971 2015-01-07T16:35:31Z Re: calender https://community.qlik.com/t5/QlikView/calender/m-p/749000#M267278 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>System Date: <STRONG>Today()</STRONG> function.</P><P></P><P>Substracting days depends on how you have your date stored.</P><P></P><P><STRONG>Today()-1</STRONG></P><P></P><P>gives you yesterday's date</P><P></P><P>In a textbox, write</P><P></P><P><STRONG>='Today: '&amp;today()&amp;'&nbsp; Yesterday: '&amp;date(today()-1)</STRONG></P><P></P><P>It'll show you today's and yesterday's dates.</P><P></P><P>It works in the same way in the script:</P><P></P><P>Load .....</P><P>&nbsp;&nbsp;&nbsp;&nbsp; today()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as SystemDate,</P><P>&nbsp;&nbsp;&nbsp;&nbsp; today()-1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; as YesterdayDate</P><P>....</P><P></P><P>Regards,</P><P>Sorin.</P></BODY></HTML> Wed, 07 Jan 2015 16:38:26 GMT https://community.qlik.com/t5/QlikView/calender/m-p/749000#M267278 isorinrusu 2015-01-07T16:38:26Z Re: calender https://community.qlik.com/t5/QlikView/calender/m-p/749001#M267279 <HTML><HEAD></HEAD><BODY><P>thank u</P></BODY></HTML> Wed, 07 Jan 2015 17:01:45 GMT https://community.qlik.com/t5/QlikView/calender/m-p/749001#M267279 2015-01-07T17:01:45Z