topic Date() in QlikView https://community.qlik.com/t5/QlikView/Date/m-p/47301#M784818 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P><SPAN style="font-size: 10pt;">Can any one </SPAN>please<SPAN style="font-size: 10pt;"> help me on below requirement.</SPAN></P><P>I am loading the below direct SQL query in Qlik by adding SQL Data connection on Top. It was loaded successfully.</P><P>But here all the dates were hard-coded.</P><P></P><P>Please help me on converting this dates extraction into dynamic format in SQL to load in Qlik.</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Please Note we are not converting the total SQL query logic's in qlik. Directly loading the SQL Query.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT mahitham 2020-11-25T16:16:04Z Date() https://community.qlik.com/t5/QlikView/Date/m-p/47301#M784818 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P><SPAN style="font-size: 10pt;">Can any one </SPAN>please<SPAN style="font-size: 10pt;"> help me on below requirement.</SPAN></P><P>I am loading the below direct SQL query in Qlik by adding SQL Data connection on Top. It was loaded successfully.</P><P>But here all the dates were hard-coded.</P><P></P><P>Please help me on converting this dates extraction into dynamic format in SQL to load in Qlik.</P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Please Note we are not converting the total SQL query logic's in qlik. Directly loading the SQL Query.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P></P><P></P><P>Thanks in advance.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Date/m-p/47301#M784818 mahitham 2020-11-25T16:16:04Z Re: Date() https://community.qlik.com/t5/QlikView/Date/m-p/47302#M784819 <HTML><HEAD></HEAD><BODY><P>Hi Mahitha,</P><P></P><P>Please explain about the date logic. On what basis, you want to change the dates (01 Jan 2018, 23 Feb 2018 and 19 Feb 2018)</P></BODY></HTML> Mon, 05 Mar 2018 04:21:21 GMT https://community.qlik.com/t5/QlikView/Date/m-p/47302#M784819 tamilarasu 2018-03-05T04:21:21Z