I am trying to load incrementing data, with the following statements.
From my initial QVD I extract the max date like so:
From test.qvd (qvd);
//Find last Create Date
LOAD max(date(CreateStamp)) as MaxDate
//Store Max Create Date into Variable
LET Last_Create_Date = peek('MaxDate',0,'Last_Create_Date');
// Delete Tickets Table
DROP Table Tickets;
Then, in my Next load statement I am trying to load WHERE to_date(createdate) > $(Last_Create_Date)
However, its not working, it seems that the Sql is not understanding the format I am sending, because if I change it to WHERE to_date(createdate) > '2017-01-01' It works.
One thing that I noticed, is that if I load the variable into a text field as such =Last_Create_Date, I get the proper date, however, if I load it with $ expansion as =$(Last_Create_Date) I get 0.000192107580... Could it be that this is what Sql is also receiving?