topic Re: How to get the current date in Qlikview in QlikView https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456524#M170443 <HTML><HEAD></HEAD><BODY><P>Hi Viju,</P><P></P><P>Use</P><P>Today() for date and</P><P>Now() for getting Date and Time.</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 14 Nov 2013 07:40:13 GMT jagan 2013-11-14T07:40:13Z How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456519#M170438 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>Can you please tell me the function which returns the current date in Qlikview.</P><P></P><P>Thanks</P></BODY></HTML> Mon, 10 Jun 2013 13:19:09 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456519#M170438 2013-06-10T13:19:09Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456520#M170439 <HTML><HEAD></HEAD><BODY><P>Date(Now())</P></BODY></HTML> Mon, 10 Jun 2013 13:20:59 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456520#M170439 tresB 2013-06-10T13:20:59Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456521#M170440 <HTML><HEAD></HEAD><BODY><P>today(<EM>timermode</EM>)</P><P></P><P>Please check the Help for the available timer modes:</P><P></P><P class="syntax"><A name="kanchor472"></A><A name="today"></A><SPAN class="Bold">today(</SPAN><SPAN class="Italic">[timer_mode]</SPAN><SPAN class="Bold"> )</SPAN> </P><P class="syntax"></P><P>Returns the current date from the system clock. The <SPAN class="Italic">timer_mode</SPAN> may have the following values:</P><P>0 Date at script run<BR />1 Date at function call<BR />2 Date when the document was opened&nbsp;&nbsp; </P><P>Default <SPAN class="Italic">timer_mode</SPAN> is 2. The <SPAN class="Italic">timer_mode = 1</SPAN> should be used with caution, since it polls the operating system every second and hence could slow down the system. </P></BODY></HTML> Mon, 10 Jun 2013 13:23:49 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456521#M170440 swuehl 2013-06-10T13:23:49Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456522#M170441 <HTML><HEAD></HEAD><BODY><P>use now() function</P></BODY></HTML> Thu, 14 Nov 2013 07:20:37 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456522#M170441 2013-11-14T07:20:37Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456523#M170442 <HTML><HEAD></HEAD><BODY><P>use now() for date time seceonds.</P><P>and today() for today date...</P></BODY></HTML> Thu, 14 Nov 2013 07:33:30 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456523#M170442 israrkhan 2013-11-14T07:33:30Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456524#M170443 <HTML><HEAD></HEAD><BODY><P>Hi Viju,</P><P></P><P>Use</P><P>Today() for date and</P><P>Now() for getting Date and Time.</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Thu, 14 Nov 2013 07:40:13 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456524#M170443 jagan 2013-11-14T07:40:13Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456525#M170444 <HTML><HEAD></HEAD><BODY><P>in text object write</P><P></P><P>=today()</P></BODY></HTML> Thu, 14 Nov 2013 07:50:43 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456525#M170444 2013-11-14T07:50:43Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456526#M170445 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Using Today() function you will get only the Today Date. If you want with the timestamp use Now() Function.</P><P></P><P>Regards,</P><P>Santhosh G</P></BODY></HTML> Thu, 14 Nov 2013 08:15:23 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456526#M170445 2013-11-14T08:15:23Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456527#M170446 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Now()::&nbsp;&nbsp; 11/14/2013 5:43:51PM</P><P>Today(): 11/14/2013</P></BODY></HTML> Thu, 14 Nov 2013 10:46:48 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456527#M170446 Nagaraju_KCS 2013-11-14T10:46:48Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456528#M170447 <HTML><HEAD></HEAD><BODY><P>You need to be mindful here. When you make use of Now() there is a continuous request of date &amp; time from the system. So try avoiding Now if you do not need current time. When you use today() make sure you pass parameter 1 [Ex: today(1)] to avoid picking document open date and get current date.</P></BODY></HTML> Fri, 27 Oct 2017 00:13:20 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/456528#M170447 Anonymous 2017-10-27T00:13:20Z Re: How to get the current date in Qlikview https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/1908885#M1218024 <P>You can use :</P> <P>=today() // give you date</P> <P>or</P> <P>=now() // give you with time stamp</P> Wed, 23 Mar 2022 15:36:42 GMT https://community.qlik.com/t5/QlikView/How-to-get-the-current-date-in-Qlikview/m-p/1908885#M1218024 kumarravi 2022-03-23T15:36:42Z