Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Date()

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.

1 Reply
tamilarasu
Champion
Champion

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)