Forum Discussion
We cannot apply operator & to types Text and Table.
Hi, I am trying to reference a date returned by another query in the SQL's where clause. As you can see in the images attached. there is a table 'me_date' that contains only one column 'business_da...
Based on your screenshot, me_date is still a table. If the date is the only value in the table you should be able to add a Table.FirstValue step to the end of the me_date query to return just the date.
Thank you. Am I not allowed to put this step within the same table? It gives me an error.