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 a 2-digit field related to month and would like to have the query only return results matching last month (currently it's October, so I would want to have results corresponding to "Where xx.xxxxx_xxxxx.MONTH = 09". Can this be set up as to not have to manually update the query every month? I'm running into errors everytime I try to set up the SQL statement. There are some other fields and workflows that I'm having similar issues with, but I figure I can work on those once I've got this one cracked.
If the results are filtered after the input tool then the workflow takes an impractical amount of time to run (hours).