Get date by month, week number, weekday and year

Absolutely @iCFO @takbb , all 4 information provided are necessary to get to 29/12/1993, and that’s perfectly illustrated by @takbb calendar there.

@takbb in terms of what constitutes being “week 1” of a month, it’s usually the week where the 1st day of the month falls in, anywhere within that week.

But in the end, it is quite straight forward, as String to Date&Time actually supports Week of month with the placeholder “W”. The only thing that it does not support is Day of week Name, at least I’ve not seen any. As a workaround, I had to convert the Wednesday to 4. I could not find a way to do this apart from doing it manually via the Rule Engine.

@Ana_Cata23 Welcome to the Knime Community. After adding the above conversion, here’s what my workflow looks like:
image

I used your same sample data:
image

And I get the results that you expected:

Here’s the workflow:

EDIT: This one’s for you @takbb:
Re: What constitutes being “week 1” of a month.
Just to confirm what I said already, here’s a test where I put Monday for week 1 for Dec 1993:
If we look at your calendar, December’s first week is that first row that you have, except that the Monday in that calendar week falls in November, and precisely on 1993-11-29, which is exactly that was returned :smiley:

Adding more samples:

5 Likes