The GetDate() function is definitely the right answer in this case as suggested above.
However in some cases it may be needed to pass values from qlikview script to an sql statement.
Here's an example (something I've already used):
let vField1 = Peek('SystemField1',0,'RelatedTableFields');
let vField2 = Peek('SystemField2',0,'RelatedTableFields');
LOAD $(vField1), $(vField2);
SQL SELECT DISTINCT $(vField1), $(vField2) FROM $(vTableName);
Hope this will prove useful in future situations