Changing string type date into date datatype

[nikhil_r]

Dears,

I am learning KNIME and I’m getting “?” in output table while converting String type date into Date data type. Please help me to solve this.

[ArjenEX]

Hi @nikhil_r

Can you please show the original format of the date? It’s hard to help right now

[mlauber71]

@nikhil_r have you tried letting the node guess the format?

[izaychik63]

In simple case Date Extractor from Palladian

Date Extractor — NodePit

will do it automatically.

[nikhil_r]

[nikhil_r]

While checking for “Guess data type and format”, throwing below error

[nikhil_r]

getting above error.

[mlauber71]

@nikhil_r you can provide a fitting pattern for your date string. Maybe you can show some examples

Error in Conversion of String format to Date format

Hi @PKRISH , please note that the case is important. You need to be careful to use the examples as they were given. So the year yyyy remains lower case. i.e. the format is: dd-MM-yyyy or d-M-yyyy (or variations of those) The single d and single M allow for day and month both as single digit, or double digit or with leading zero. If you specify dd or MM it only matches where the day / month is represented as 2 digits. i.e. d and M are less restrictive than dd and MM It’s not entirely obvio…

Date & Time Integration | KNIME

[izaychik63]

I recommended node from Palladian. You need to install Palladian first.

[tqAkshay95]

Hello @nikhil_r ,

can you provide sample data ?