I am trying to filter out rows that are not current year. For example, I have a file that shows annual payments made to individuals and what dates they were made on. This includes all the payments from previous years as well as current. So the date column shows yyyy-mm-dd. I only want to see the rows that have the current year without having to update the node each year to reflect the change. Any suggestions?
With the Create Date&Time Range node, you create the execution-date. This is converted to a flow variable and used in a RowFilter node to filter the rows of the current year .