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 have an issue when trying to filter date data in a datetime format in an SQL data input that i'm using. I want to exclude data before 1st November 2016
Field name = dss_update_time
Example date format = 2012-02-28 14:15:12
Date filter in SQL input in Alteryx:
When i put in a date filter as the input tool, it doesn’t filter out any data and gives me the following error:
Input Data (1) Error SQLExecute: [Microsoft][ODBC SQL Server Driver][SQL Server]The conversion of a varchar data type to a datetime data type resulted in an out-of-range value.[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.
A simple > 2016-10-31 works but doesn't filter anyone out!
Please can you advise what I should put in the datetime filter or whether I need some sort of PreSQL statement. Thanks
Please see highlighted yellow field where filter has been applied as '2019012'. I want to replace '2019012' by some code which upon workflow running will always convert current system time into 'YYYY0MM' format and pull data for most recent period.