How to extract a date from a string?

[giad]

Hi, I have this field "status_created_at which is a string:

I need to convert to a date or extract only the YYYY-MM-DD but I cannot with extract date to string node and string to date node…
How can I do that?

In this field I note there is a strange text T between date and time…
Can you help me please?

Thanks
Giada

[izaychik63]

Try

Date Extractor — NodePit

From Palladian

[umutcankurt]

alternative solution

[ipazin]

Hi there @giad,

you can also use String Manipulation node with substr() function to get only first 10 characters from your column. Or you can convert String column to Date&Time column using String to Date&Time node followed by Modify Time node with option Remove time.

@giad

In this field I note there is a strange text T between date and time…

“T” is part of KNIME Date&Time column type. Probably you had this column as Date&Time type and somehow converted into String which left “T” between Date and Time parts…

Br,
Ivan