Manipulating Dates

Hi,

I have been using Knime for the past 2 years. I am tasked with migrating tableau prep flows into Knime workflows.

In tableau prep I can make a date and filter to keep this year and last years data in 2 lines of code. My question is what is the most efficient way to do this in knime?

When the date is available to me I have used this workflow in knime:

I am in another scenario where I have the year and month in separate columns and need to make a date myself. I would also like to know the best way to do this.

I was expecting the expression node to have some functions to work with dates like tableau. If I had access to these I am sure this would be a lot easier.

Looking forward to hearing what the most efficient solution is.

Many thanks,

Fin