String to Date

KNIME Analytics Platform
1

Hi Knimers

I can't understand why my String to Date/Time node is not working in the example bellow.

Any tips?

Best

 

2

What was the configuration?
 

3

 

Here it is:

Tks

4

Somebody correct me if I'm worng, but I think your string needs to be more or less in the same format as the "Date format" selection in your String to Date/Time node. This can be accomplished (inefficiently) with a series of String Manipulation nodes. Here's a quick example, but there's for sure a better way

5

Hi all!

Here it is how it's worked for me:


1-String Replacer: "January" to "01"

2-String Replacer: " ," and " " to "/"

3-String to Date/Time: Date format = MM/dd/yyyy

Thank you all!