Today() is a qlikview function. You can't use qlikview functions in SQL statements since those are processed by the dbms and not by qlikview. According to SalesForce.com SOQL and SOSL Reference you can use TODAY instead.
A fieldExpressioncan use a date literal to compare a range of values to the value in adateordateTimefield. Each literal is a range of time beginning with midnight (12:00:00). To find a value within the range, use=. To find values on either side of the range, use>or<. The following table shows the available list of date literals, the ranges they represent, and examples:
Date Literal Range Example YESTERDAY Starts 12:00:00 the day before and continues for 24 hours. SELECT Id FROM Account WHERE CreatedDate = YESTERDAY TODAY Starts 12:00:00 of the current day and continues for 24 hours. SELECT Id FROM Account WHERE CreatedDate > TODAY