Date()

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I am loading the below direct SQL query in Qlik by adding SQL Data connection on Top. It was loaded successfully.

But here all the dates were hard-coded.

Please help me on converting this dates extraction into dynamic format in SQL to load in Qlik.

Please Note we are not converting the total SQL query logic's in qlik. Directly loading the SQL Query.

Thanks in advance.

[tamilarasu]

Hi Mahitha,

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)