I’m trying to filter dates in a Date&Time row filter using variables given by a date and de next day created by a date&time shift module:
if i use the date in te fisrt column (campaing effective date) as a variable in the filter i don’t have any issues, however when i try to use the date from the second colum (campaing effective date (shift)), the filter doesn´t recognize the variable.
When using the date and time node, I am trying to make my variable date values (campaign effective date and campaign effective date shift) recognizable, thus being able to use them as input values for the filter. The issue I am facing is that the filter node is only recognizing the first date column inside to filter, as you can see in this second image:
For “End”, you have selected a numerical duration (Years). So, whatever you use as the end_date_time, it will always be 1 year after the start date. If you want your flow variable to take effect, select “Date&Time” option for “End” as well.
I’d say you are missing the Table Row to Variable node after the Duplicate Row Filter. It looks like you are using a variable that is generated by the Group Loop Start.
If you put mentioned node in your workflow and then connect it to the row filters you’ll have both options and KNIME will filter all data accordingly.