Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I get the following error message
Error: Connector reply error: SQL##f - SqlState: S1000, ErrorCode: 4294960590, ErrorMsg: [Teradata][ODBC Teradata Driver][Teradata Database](-6706)The string contains an untranslatable character.
I have the following variable set up which is causing the problem:
Let vDateEnd = num(year(today()-1))&'-'&num(month(today()-1),'00')&'-'&num(day(today()-1),'00');
Load
SQL
where t.start_txn_date between '$(vDateStart)' and '$(vDateEnd)'
Any idea how I can formulate the vDateEnd variable?
Thanks
You could try to declare the variables using the syntax of the source system .. the qlik syntax wont be processed ..