Qlik Sense Load Error

[shamitshah]

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

[AdiPai]

You could try to declare the variables using the syntax of the source system .. the qlik syntax wont be processed ..