Discussion Board for collaboration related to QlikView App Development.
I am trying to define a variable as follows:
Let vStartDate = '01-JAN-16';
Let vLimit = 'TO_DATE('$(StartDate)', 'DD-MON-YY')';
When I am trying to load the variables I am getting the following error :
Can someone help me with the correct syntax ?
Go to Solution.
did you try my prev post?
Set vLimit = TO_DATE('$(vStartDate)', 'DD-MON-YY');
SQL Select ......
Where Transaction_Date >= $(vLimit)
or with quote
TO_DATE is not a Qlik script function, and your statement itself does not evaluate to a valid statemten because of the quoting.
Let vLimit = Date#('$(vStartDate)','DD-MMM-YY');
do you need a vLimit var for an Oracle where clause or something similar?