Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Passing date variable to Teradata

In my Qliksense script, I created a date variable using this code:

LET vMinDate = MonthEnd(AddMonths(Today(),-13));

Next I have a SQL SELECT statement where I'm trying to limit the data from my table by using the date variable above (vMinDate) in the WHERE condition....

WHERE "DATA_DT" >=  $(vMinDate);

Well, the query runs, but it ignores the date condition and returns ALL the dates in my table.  For example, running the code today, the value for vMindDate is 12/31/2014.   And when I abort the query, it shows that date value in the data load box.  But again, when it runs it returns ALL DATA_DT values.

I presume Teradata is not recognizing the the date format.  What can I do?  Is there code to change the date variable to the 1141231 format Teradata also likes?  Or another way to create the variable to use in the SQL?


1 Reply
Partner - Creator
Partner - Creator


Can you please update, how you were able to solve this issue ?