I’ve been working with some nodes. I have some data extractions that I’m doing on Knime, part of what I need to do is to take the set of data I currently have and filter only those that have a valid price for current dates.
In this case this is how the validation should work as a concept:
Take all the list of codes and verify the dates (valid from and valid to)
-Valid From is <= Start of month = TRUE
-AND Valid To is >= Start of Monht = TRUE
I want to see only those codes that are compliant with both conditions. I’ve seen that I can filter by date but it’s a static date.
Does anyone know if there’s a way to set the date as “start of month” meaning that this will be dynamic and every month the date that I should be validating against should be the current month.