This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I use custom SQL statements in many of my input tools. I also use the global system variable CURRENT_DATE to dynamically get a date range in my queries. Alteryx is trying to parse and understand the query, but it fails to understand CURRENT_DATE. Each time the time I selected to view the SQL in the input tool, a parsing error is generated, "Invalid SELECT statement. Unexpected token "CURRENT_DATE" at line xx, pos xx". Dismissing this error by clicking OK is all that is needed to workaround, but this is still less than ideal.
Please correct this so CURRENT_DATE will be an "expected token".