Qlik Community

Qlik Sense App Development

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

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?

THanks!