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:
I used your same sample data:
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
Adding more samples: