Workbench Filter Dataset on a Year of a Date
I am trying to bring in some ODBC datasets, but only want workbench to pull in anything that is for the current year. I have invoice date in my dataset as a column that I want to use the following transformation to isolate only invoices for this year. See screenshot below.
I know that I can use redshift/SQL/Magic to do this but wanted to try and do it on workbench to avoid having to eat of ETL time.
Any help would be amazing.