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'm having a very frustrating problem and I need help.
I'm trying to create a dummy variable for a theoretical time period so I can go 'back in time' and look at logs. I'm using tables that have date fields.
The code that is generated from my INDB output is as follows:(the where clause is the important part here)
,('2019-12-29'::date) AS date_of_enquiry
(SELECT * FROM [source table])
AS a ) AS a ) AS A
WHERE effective_date::DATE <= Date_of_enquiry::DATE
This successfully runs in my Greenplum editor. But every time I run it in Alteryx, I get an error right at the where clause:
I don't understand what the problem is. The date types are timestamp data fields (rather than string), and the variable I'm creating is a datetime. What am I doing wrong?!??! I've had this problem in other workflows, but casting things to ::date helped.